SUMMARY

• Over 14+ years of experience in Microsoft Business Intelligence Tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Services (SSAS), SQLServer development and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MS SQL Server technology.
• Experience in Azure SQL Databases and MS SQL Server 2016/2014/2012/2008 R2with OLTP and Business Intelligence delivery using SQL Server Integration Services and SQL Server Reporting Services.
• Experience in Data migration using Azure Data factory (ADF) and Database migration to Azure Cloud.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Worked on Normalization and De - Normalization techniques for both OLTP and OLAP systems.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursorsand CTE.
• Experience with SQL Server development and T-SQL in writing stored procedures, creating user defined functions, constructing triggers, tables, views, indexes, user profiles. Scheduling & Monitoring Daily Jobs, DB-Maintenance Plans, runjobs for Re-indexing, and Reorganize.
• Strong experience with ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Good Experience in creating Master Child Packages in SSIS and in generating on-demand and scheduled reports for business analysis using SSRS.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS.
• Implemented Database deployments using Azure CI\CD with pipelines and DACPAC.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Experience in creating sub reports and parameterized Queries for generating reports in SSRS.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• Experience in Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands.
• Involve in Query Tuning by looking at Indexes, joins, coding standards with the help ofExecution Plans, query plans SQL Profiler, DTA Performance tools etc.
• Proficient in monitoring SQL Server Performance using SQL Profiler, Query Analyzer, Query Tuning, Handling locking, blocking, deadlock situation and Windows Performance Monitoring.
• Involved in working with Tempdb database manage, maintain, and Configuration for optimal performance.
• Good Experience in Database Backup, Recovery and Restoring as daily activities.
• Knowledge of high availability Technologies, including SQL Server Clustering, Log shipping, Mirroring and Replication. Knowledge in disaster recovery, backup/restore.
• Creating and maintaining the indexes using reorganize and rebuilding indexes with suitable fill factor values.
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

Languages: T-SQL, SQL, VBScript, XML

RDBMS: SQL Server\Azure 2016/2014/2012/2008 R 2/2008/2005/2000

DB Deployment tools: Azure CI\CD, DACPAC

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio. Master Data services (MDS). Parallel Data Warehouse (PDW). Azure Data Factory (ADF). Data Bricks.

Tools: and Utilities: SQL Server Management Studio, SQL Server Profiler, Import & Export Wizard, Visual Studio, Visual Source Safe, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, TFS and GIT

Third Party tools: SQL Sentry, Idera and RedGate

PROFESSIONAL EXPERIENCE

Confidential, GA

System Analyst/Technical Architect

Responsibilities:

• Design and Develop of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server.
• Migration of SQL and SSIS to Azure Cloud.
• Created Data migration packages using Azure Data Factory.
• Collecting the data from the sources and based on their requirements loading the data using SQL server Integration services (SSIS).
• Implemented all the tax calculations (Rule Engine) using SQL server.
• Creating complex stored procedures According to use cases document.
• Uses the various tasks and Containers like for loop and for each Loop, Bulk insert task, Execute package Task, File System task in SSIS.
• Worked on the SQL Server database, creating tables, stored proceduresetc.
• Worked on SQL Server Performance using SQL Profiler, Query Analyzer.
• Involved in DBA activities are like performance tuning, Backup and restores and DB maintenance activities.
• Creating and maintaining the indexes using reorganize and rebuilding indexes with suitable fill factor values.
• Implemented SQL server parallel execution using CLR.

Environment: MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Redgate, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, GA

System Analyst/Technical Architect (MSBI (SSIS/SSRS)/SQL Server Developer/DBA)

Responsibilities:

• Design and Develop of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server.
• Collecting the data from the sources and based on their requirements loading the data into it.
• Creating the SSIS Packages inorder to load that data into the database.
• Implemented all the tax calculations using SQL server.
• Creating stored procedures According to use cases document
• Created custom ETL architecture for Logging information of SSIS
• Uses the various tasks and Containers like for loop and for each Loop, Bulk insert task, Execute package Task, File System task.
• Worked on the SQL Server database, creating tables, stored procedures and etc.
• Worked on SQL Server Performance using SQL Profiler, Query Analyzer.
• Involved in DBA activities are like performance tuning, Backup and restores and DB maintenance activities.
• Creating and maintaining the indexes using reorganize and rebuilding indexes with suitable fill factor values.
• Implemented SSIS multi-threading for parallel execution.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MDM(Master Data Management) Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential

Sr Software Engineer(BI (SSIS/SSRS)/SQL Server Developer/DBA)

Responsibilities:

• Design and Develop of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server.Documenting all the packages those are created.
• Migrating DTS 2000 SSIS packages to 2008 SSIS packages.
• Uses transformations like Derive Column, Conditional Split, Aggregate, Lookup, Merge join, Data conversion, Row Count, sort and execute SQL Task to load data into Data Warehouse.
• Uses the various tasks and Containers like for loop and for each Loop, Bulk insert task, Execute package Task, File System task.
• Involving in Database design and implemented complex business logic in stored procedures, functions, Triggers
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through etc.
• Created different Parameterized Reports (SSRS 2008) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like internal, default (queried and non-queried parameters).
• Created Automate reports, Ad-hoc reports and etc. based on the requirement.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MDM(Master Data Management)Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports, Business Objects, informatica.