SUMMARY

• Complete understanding of Software Development Lifecycle and core area of experience in validatingend - to-endbusiness scenarios of B2B (Business to Business) applications.
• Enterprise Applications developed expertise in SSIS/SSRS/SSAS.
• Good exposure to entire Software Life cycle Phases (Feasibility. System studies. Design. Coding. Testing. Implementation and Maintenance).
• Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology. like Data Warehouse Bus.
• Complete understanding of Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Experience in creating Index. Views. complex Stored Procedures. appropriate user defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.
• Having over 5 years of strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS.
• Extensive experience in MS SQL Server 2008/2008R 2/2012/2014 /2016/2017 and solid hands on experience in installing. configuring. managing. monitoring and troubleshooting SQL Server in Dev. Testing and Production environments.
• Experienced in writing Parameterized Queries for generating Tabular reports. Formatting report layout. Sub reports using Global Variables. Expressions.
• Functions. Sorting the data. defining data source and subtotals for the reports using SSRS.
• Proficient with SQL Server Management Studio. SQL Server Business Intelligence Development Studio (BIDS)/SSDT. SQL Profiler. Performance Monitor.
• Experienced with the creation of SSIS packages in Data Extraction. Transforming. and Loading (ETL) from various sources using SQL Server Integration Services. Bulk Insert. and Bulk Copy Program (BCP).
• Extensive experience with writing T-SQL scripts. stored procedures. triggers and functions. creating SQL Server Jobs/alerts. and scheduled tasks to automate tasks.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2014/2016/2017

BIDS/SSDT: SQL Server Integration Services (SSIS). SQL Server Reporting Services (SSRS); SQL Server Analysis Services (SSAS)

Data modeling tools: Erwin Data Modeler ER/Studio. Oracle SQL developers data modeler . Data Vault

Visualization tools: SSRS. Power BI

Source Control tools: Team foundation Server.

Software project management tools: Jira. Rally CA. Agile software development approach

Microsoft Office tools: MSWord. Excel. Power Point. SPSS and applications and file management systems.

PROFESSIONAL EXPERIENCE

Confidential

DATA MIGRATION CONSULTANT (ETL)

Responsibilities:

• Worked on gathering requirements. confirming specific objects. transformation rules and filtering criteria
• Design. build. test ETL for data and/or file/attachment migrations
• Converted file attachments into BLOBS and migrated them from file server System to SQL server DB system
• Executed mock and final data migrations. including business validation
• Worked on object mapping. metadata cloning/mapping from source to target.
• Reviewed and define ETLs.
• Developed cross validation rules to ensure mapping accuracy
• Supported production release during migration and high per care period.
• Developed ETL (data transformations and data movement) using SSIS, SQL server.
• Owened ETL efforts for Development, QA and Production on the data migration

Confidential

MS SQL SERVER/ETL / BI DEVELOPER

Responsibilities:

• Partnered with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2016.
• Designined, developed and maintain business intelligence solutions.
• Crafting and executing queries upon request for data.
• Presenting information through reports and visualization.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Designed. created and regular tuned of physical database objects (tables. views. indexes) in MS SQL Server 2016 to support normalized and dimensional models.
• Worked as a primaryT-SQLdeveloper in creating complex Stored Procedures. triggers. cursors. tables. views and other SQL joins and statements for applications.
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging.
• Change Data Capture (CDC). Data Balancing & Reconciliation. Exception Handling & Reject Recycling. Surrogate Key Generation & Assignment. Data Lineage Tracking. ETL Auditing. etc.
• Used SQL Server Profiler to trace long running queries for optimizing databases.
• Provided day to day support of data warehouse and troubleshooting of existing process and procedures.
• Transferred data from various data sources/business systems including MS Excel. MS Access. Flat Files.
• Oracle etc. to SQL Server using SSIS various features such as multitasking. conditional split. union. union all. merge. lookup. fuzzy lookup. data conversion.
• Worked with data modeling team to review and critique data architecture design and implementation work developined solutions using SQL Server, ETL - SSIS, Data Model and Stored Procedures
• Worked with Microsoft SQL Server DBAs in Enterprise Database Management group to troubleshoot problems and optimize performance
• Troubleshot SQL Server related CPU/Memory. I/O using Performance Monitor; Collaborated with system teams and development teams for codes release including MSSQL database changes and patches.
• Documented All MSSQL database structures and functionalities. Worked with Auditors and Provided Database related documents.
• Worked on 7X24on-callrotation to support the production environment.

Confidential

MS SQL DEVELOPER/ BI DEVELOPER

Responsibilities:

• Involved in gathering requirements. performing source system analysis and development of ETL jobs to migrate data from the source to the target Data Warehouse.
• Presenting information through reports and visualization.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Designed and deployed SSIS packages using various Transformations such as Multicast. Merge Join. Lookup. Fuzzy Lookup.
• Fuzzy Grouping. Slowly Changing Dimension. Aggregate. Conditional Split. and Derived Column Transformations.
• Transformed data from MS SQL Server 2008R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Built reports in SSRS for errors generated by SSIS Packages; generated Reports using Data Source Views in Report Builder; created Drill Down. Drill through. linked and sub reports using SSRS.
• Generated various type SSRS reports that could be used to send information to different vendors. clients and managers.
• Scripted several database maintenance tasks reducing manual processes and related overheads.
• Assisted in production of OLAP cubes. wrote queries to produce reports using SQL Server 2008R2 Analysis Services (SSAS) and Reporting service (SSRS).
• Designed. developed. tested. and implemented SSRS reports withmulti-parameter.chart.drill-down.drill-through. sub-reportand interactive sorting capability for business teams.
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report. parameter report. and dashboard with charts and drill down function.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Tuninglong-runningSQL Queries. Procedures and Functions using SQL Profiler. SQL analyzer. Index tuning wizard.
• Work with development teams to make best schema design that balances feature requests with performance concerns.
• Coordinate with the team that responds to all system problems in order to reduce or eliminate production problems by analyzing production usage information and using that information to design a better architecture.
• Built efficient ETL packages with SSIS to fetch. cleanse and transform data from various types of sources. Develop package configurations dynamically as well as populating variables dynamically.
• Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.