Bhaskar Punuru
Bangalore
Summary
Driven business intelligence professional managing areas such as data mining, database management and report development. Meticulous and hardworking with a disciplined and methodical approach. Exceptional skills in project management, problem-solving and verbal and written communication.
Overview
10
10
years of professional experience
Work History
Senior Consultant
Blackbuck Insights
Bangalore
10.2021 - Current
- Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
- Worked closely with the business users to understand the requirements and convert them into project level technical capabilities.
- Worked on SQL Server Integration Services SSIS to integrate and analyze data from multiple heterogeneous sources like Oracle, SQL Server, SharePoint, and external Flat files.
- Writing SQL queries to create end-user reports /Developing SQL Queries and stored procedures in support of ongoing work and application support.
- Created requirement specifications documents, user interface guides, functional specification documents, ETL technical specifications document and test case.
- Involved in requirement gathering, Design, testing, project coordination and migration.
- Maintained proper communication between other teams and client.
Business Systems Analyst
Xoriant Solutions
Bangalore
12.2020 - 10.2021
- Analyzed business needs and translated them into system requirements.
- Developed ETL packages for data loading from various sources such as flat files, files and Oracle databases into the Data Warehouse using SSIS.
- Collaborated with database administrators to design database objects including tables, views, stored procedures and user-defined functions required for ETL process.
- Assisted team members with their queries regarding best practices followed while developing solutions using Microsoft BI tools like SSIS and SSRS.
Consultant
Manthan Software Services
Bangalore
06.2016 - 08.2020
- Analyze business requirements, technical specification, and physical data models for ETL mapping and process flow.
- Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
- Created SSIS packages to load the data from files and multiple Databases to Destination tables.
- Creating SQL jobs and scheduling SSIS packages.
- Performed Database tasks such as creating database objects (tables, views, Procedures, Functions).
- Coordinate and develop all documents related to ETL design and Development.
- Involved in Production deployment and Knowledge transfer to Production support team.
Software Engineer
TEK Systems
Bangalore
07.2014 - 01.2016
- Analyze business requirements, technical specification, and physical data models for ETL mapping and process flow.
- Created SSIS packages to load the data from files and multiple Databases to Destination tables.
- Creating SQL jobs and scheduling SSIS packages.
- Performed Database tasks such as creating database objects (tables, views, Procedures, Functions).
- Coordinate and develop all documents related to ETL design and Development.
- Involved in Production deployment and Knowledge transfer to Production support team.
Education
Master of Science - Computer Networking
University of Bedfordshire
England, United Kingdom12-2011
Skills
- Databases : MS SQL Server, Oracle and Amazon Redshift
- Database Tools : Sql Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
- Development Skills : T-SQL, PL/SQL, SSIS/SSRS, Power BI
- Languages : SQL, PL/SQL and basic knowledge on Python
- Methodologies/ Cloud Technologies : Agile, Jira Microsoft Azure
Timeline
Senior Consultant
Blackbuck Insights
10.2021 - Current
Business Systems Analyst
Xoriant Solutions
12.2020 - 10.2021
Consultant
Manthan Software Services
06.2016 - 08.2020
Software Engineer
TEK Systems
07.2014 - 01.2016
Master of Science - Computer Networking
University of Bedfordshire
Similar Profiles
Vaishnavi SureshVaishnavi Suresh
Consultant at Blackbuck InsightsConsultant at Blackbuck Insights
HARITHA VRHARITHA VR
Technical Manager/ Sr. SAFE Scrum Master at BlackBuck InsightsTechnical Manager/ Sr. SAFE Scrum Master at BlackBuck Insights
Vaishnavi SureshVaishnavi Suresh
Consultant at Blackbuck InsightsConsultant at Blackbuck Insights