• Attended daily scrum meetings, discussed new requested features/user-stories/tasks with Business Analysts and updated the status of tasks assigned on Agile Platform.• As a key developer, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, SSIS, Power BI, ADF2, SSAS, and other Azure tools.• Assisted and supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and… Show more • Attended daily scrum meetings, discussed new requested features/user-stories/tasks with Business Analysts and updated the status of tasks assigned on Agile Platform.• As a key developer, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, SSIS, Power BI, ADF2, SSAS, and other Azure tools.• Assisted and supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.• Implemented performance tuning on complex stored procedures, views, user defined functions and queries by creating proper indexes and optimizing the existing ones.• Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.• Migrated on-premise SQL server schemas to the cloud on Azure SQL Server and maintained databases across both on-premise and cloud deployments.• Built efficient ETL packages, using both SSIS and ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2. Build workflows to automate data flow using Python and ADF2.• Performed incremental data loading in order to synchronize data changes between OLTP and OLAP databases using SSIS packages, execute SQL task and merge.• Send email notifications about ETL issues reports to development team by using Send Mail Task/Script Task/Execute SQL Task along with system stored procedure to send emails. Show less

• Analyzes complex data sets and extracts actionable insights using various economic, financial, customer and marketing methodologies.• Synthesizes data, insights, and consumer research to create presentations that make fact-based recommendations.• Worked with the Marketing Analytics leadership to communicate and recommended approaches to senior leaders and anticipate the future needs of our customers.• As a key member of BI team, delivered the best results to the developmental… Show more • Analyzes complex data sets and extracts actionable insights using various economic, financial, customer and marketing methodologies.• Synthesizes data, insights, and consumer research to create presentations that make fact-based recommendations.• Worked with the Marketing Analytics leadership to communicate and recommended approaches to senior leaders and anticipate the future needs of our customers.• As a key member of BI team, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, SSIS, SSRS and Power BI.• Created SSRS and Power BI reports such as Resource Management Reports for HR department that shows KPI’s of different projects, number of employees worked in that project, sick leaves, PTO’s so on. Also created Expense Report for HR department that shows how their budget is being used on monthly basis on social events, training programs and different cultural enrichment projects etc.• Created internal SSRS and Power BI reports for development team such as ETL Statuses/ETL Failures Report that shows the ETL issues that we captured at runtime about Control Flow Tasks and Data Flow Transformations when we run ETLs.• Gathered and analyzed business requirements and translated business needs into long-term business intelligence solutions.• Involved in creating interactive, accurate, insightful, and well- organized Power BI reports/dashboards to support businesses in their data driven strategic planning.• Built custom and efficient stored procedures, CTE’s, functions (UDF), DML triggers, indexes, tables, views as part of the project.• Worked as a SQL Developer, Project included developing complex SQL queries, integration and reporting and coordinating with the offshore team.• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency. Show less

• Involved in developing systems with a high level of performance and reliability.• Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships.• Created constraints, defaults, rules, and triggers to maintain the referential integrity of the database.• Involved in loading flat files, excel sheets into the OLTP database. Also, developed T-SQL stored procedures/functions/expressions… Show more • Involved in developing systems with a high level of performance and reliability.• Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships.• Created constraints, defaults, rules, and triggers to maintain the referential integrity of the database.• Involved in loading flat files, excel sheets into the OLTP database. Also, developed T-SQL stored procedures/functions/expressions, CTEs, indexed views, stage tables to process the data and populate them in the appropriate destination tables.• Created Sub-queries and Joins for complex queries involving multiple tables from different databases. Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.• Created indexes and views, stored procedures to enhance database/application performance.• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting.• Developed ETL packages to extract, transform and load into Data ware house using of SQL Server Integration Services (SSIS).• Involved in design and creation of data mappings from sources like Flat files, DB2, Excel files, OLEDB and ODBC data sources which contains bulk data.• Deployed SSIS packages into various Environments (Development, Test and Production) using Deployment Utility.• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1/ type 2 changes.• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).• Created Incremental Load ETL packages using For Each Loops, Sequence Containers, Script Tasks, Conditional Split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, Union all, etc. on BIDS 2008R2/2012.• Solved many critical/challenge issues raised by the team about ETLs. Show less