Satyaprakash Mohapatra
Consultant
Bangalore
Summary
Multi-tasking Consultant well-known for successfully taking projects from beginning stages to completion. Polished and professional offering proficiency in SQL BI and Azure technology. Commended for consistently meeting new technical challenges and finding solutions to satisfy customer needs.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
2
2
Certifications
3
3
Languages
Work History
Consultant
KPMG Global Services
BENGALURU
04.2020 - Current
- Working as SQL server developer and SSRS reports developer for large bank in UK.
- Working in SSIS and Azure Data Factory to load client data to data warehouse.
- Working in Tableau to create and maintain dashboards for client.
- Supported clients with business analysis, documentation and data modeling.
- Improved systems with addition of new features and infrastructure.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
Assistant Manager
Deloitte Touché Tohmatsu LLP
Bangalore
10.2018 - 03.2020
- Worked in Tax Analytics team as SQL Server Developer.
- Worked in GSTR1 and GSTR 2A reconciliation process.
- Developed custom database objects, stored procedures and delivered application support.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
Business Analyst
Genpact India Private Limited
BENGALURU
07.2017 - 10.2018
- Worked as SQL BI resource for large retail sector project.
- End to end project execution (Documentation, Designing, Unit testing and Defect Fixing).
- Designed and implemented TSQL queries for reporting and complex solution development.
- Documented analysis results and provided performance improvement feedback.
- Developed reusable components for exploitation in coding and documentation.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications using SSIS.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
Programmer Analyst
Cognizant Technology
BENGALURU
03.2014 - 03.2017
- Interacted with clients to understand their requirements
- Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS.
- Involved in creating multiple parameterized stored procedures to apply business logics to data.
- Created parameterized reports, Drill down and Drill through reports using SSRS.
- Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse using various transformations like Lookup, Derived column, Data conversion, Conditional split, SQL task, Script task and Send Mail task etc
- Created ETL (SSIS) Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008
- Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
Education
B.Tech - Electrical & Electronics Engineering
GIET
Odisha 07.2008 - 06.2012
XII -
Board of Secondary Education
Odisha 06.2005 - 03.2007
Class X -
C.H.S.E
Odisha 06.2004 - 03.2005
Skills
T-SQL coding
SQL analytics
SQL development
SSIS
SSRS
Tableau
Azure Data Factory
Azure
Data Warehousing
Reporting capabilities
Certification
Successfully Completed Microsoft Azure Fundamentals AZ 900 certification.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
The way to get started is to quit talking and begin doing.
Walt Disney
Timeline
Consultant
KPMG Global Services
04.2020 - Current
Assistant Manager
Deloitte Touché Tohmatsu LLP
10.2018 - 03.2020
Business Analyst
Genpact India Private Limited
07.2017 - 10.2018
Programmer Analyst
Cognizant Technology
03.2014 - 03.2017
B.Tech - Electrical & Electronics Engineering
GIET
07.2008 - 06.2012
XII -
Board of Secondary Education
06.2005 - 03.2007
Class X -
C.H.S.E
06.2004 - 03.2005