PROFESSIONAL EXPERIENCE:

• More TEMPthan 9 years of experience in PBM as a SQL Server Developer dat includes Database Design, Development, Implementation, Maintenance and Documentation of MSSQL Server 2017/2012/2008R2/2008 and its Client Server Applications.
• Strong hands - on experience in SQL Server Integration Services (SSIS).
• Experience in SQL Server Reporting Services (SSRS).
• Knowledge in SQL Server Analysis Services (SSAS).
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Involved in SQL Server database upgrade Confidential Instance and Database level for different versions SQL Server 2000/ 2005/ 2008 R2/2012/2014/2016/2019. Good experience in migrating databases from Oracle, MS Access to SQL Server database instances.
• Strong knowledge in Database normalization theory techniques, Data flow diagrams, Data dictionary, Entity relation modelling and design techniques.
• Knowledge in table partitioning.
• Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS).
• Knowledge in SQL Server Analysis Services (SSAS).
• Expertise in creating dynamic packages for Incremental Loads and Merging data from various Data sources (Oracle, SQL Server, Access, Excel, Flat Files and XML) using Connectors, tasks, and transformations.
• Expertise in merging data from various Data sources (Oracle, SQL Server, Access, Excel, Flat Files and XML) using Connectors, tasks, and transformations in SSIS packages.
• Experience in developing, configuring, and deploying SSIS packages and providing security and integrity.
• Created Reports wif complex formulas and to query the database for business Intelligence.
• Worked on building a Data Warehouse and implementing an ETL solution for loading Data warehouse.
• Extensive experience in creating business, functional and technical documentation.
• Excellent verbal, written communication, presentation, and problem-solving skills.
• Experience in writing and debugging Stored Procedures, Views, and Functions using T-SQL Scripts.
• Expert in creating Joins, Indexes, Triggers, and Sub-Queries to simplify complex queries involving multiple tables.
• Efficient in building recursive queries using CTEs (Common Table Expressions).
• Experience in Data Modelling (Logical and Physical Design of Databases), Normalization/de-Normalization and building Referential Integrity Constraints, Unique Key Constraints.
• Expertise in Error Handling wif @@error and wif Try and Catch.
• Created Temporary Tables and Table Variables while creating complex queries in SQL Server.
• Efficient in Implementing Transactions in Stored Procedures.
• Expert in Query Tuning, including Updating Statistics, Re-building, and Re-organizing Indexes.
• Resolved issues wif Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio

Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Power BI

Databases: SQL Server 2017/2016/2012/2008R2/2005

Programming Languages: T-SQL, C, C#, C++, Java Script, HTML, ASP, ASP.Net, XML

Development skills: T-SQL, SSIS/SSRS/SSAS

Operating Systems: Windows NT, Windows 2008, 2003, XP, Windows 7, Windows 10

Technologies: MSSQL, MSBI

PROFESSIONAL EXPERIENCE:

Confidential, Twinsburg, OH

Senior SQL BI Developer

Responsibilities:

• Implemented Event Handlers and Error Handling in SSIS packages.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Tuned stored procedures and TSQL queries for performance issues.
• Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures
• Optimize SQL queries for better performance. Tuning of Oracle stored procedures and developed business logic in database layer using PL/SQL. Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.
• Worked wif Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Design and develop new ETL processes for existing applications using SSIS 2016 and 2019
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2017/2012 Enterprise, BIDS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS)

Confidential, Mechanicsburg, PA

SQL BI Developer

Responsibilities:

• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs, SIT, UAT, Data Reconciliation and validation.
• Created packages in SSIS wif error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Tuned Stored Procedures for performance.
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Developed Stored Procedure dat takes Database name, Subscriber, Publisher server names and some other input parameters and creates publication for the database, adds articles to the publication, adds subscription to the publication, and starts the snapshot agent
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Extracted history data from flat files onto more TEMPthan 140 SSIS packages by deploying them to different SQL Instances using Integration services catalog and created SQL agent jobs.
• Development of SSIS packages during Conversion, Unit Testing, Defect resolution in the Testing Phases of the project.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS).
• Responsible for strategic planning and execution, performance, deliverables quality and schedule of data migration work stream.
• Established and facilitated work-stream collaboration sessions to clearly define migration data quality and exit criteria for each migration trial as well as collaborative sessions to evaluate progress and results of migration cycles.
• Creating Azure Data factories for loading the data to Azure SQL database from Cosmos platform.
• Created SSRS Reports and deployed on the report server and scheduled the reports using subscriptions and created jobs to deploy the reports to a specific location after every Release.
• Testing the Application before moving the code to the higher environments to reduce the defect percentage rate.
• Involved in Resolving the Defects from the Defect Tracking Tool JIRA in all the environments from STAGING, UAT and PROD.

Environment: SQL Server,Microsoft CRM 2015, JIRA,Git,MS SQL Server 2008/2019, TSQL, SQL Server 2008, SQL BI Suite (SSIS, SSRS) /DBA, Oracle 11g, JIRA

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Actively coordinated and involved wif business and users to gather and analyze requirements.
• Involved in the requirements gathering, documentation of business and system specification requirements, and analysis of specifications.
• Involved in the preparation of design documents, estimation of the effort and scheduling.
• Testing of the product and co-ordination of the implementation of the project.
• Writing Test plans, documenting test results, walkthrough wif the business.
• Involved in Training presentations and training the stakeholders of the new tool and its features.
• Developed an automated process of fetching the files from FTP and processing them as per business requirements.
• Developed complex queries, stored procedures, views, and constraints, triggers using inner and
• uter joins, unions, and SQL Statements for various applications in different environments.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Worked wif MDX to query cube’s data.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Created actual sales and target sales view wif table calculations to see the difference between each quarter.
• Report parameters included single valued parameters, multi-value parameters which also consist of
• different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created logging for ETL load Confidential package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented various performance tuning techniques like removing unwanted columns, Tuning the
• DefaultBufferMaxSize, Checkpoints and Indexing.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Confidential

SQL Developer

Responsibilities:

• Designed SSIS Packages to extract data from various data sources such as Excel spreadsheet, and flat files into SQL Server 2005 and 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Creating dynamic SSIS packages along wif XML configuration file.
• Created SSIS script tasks, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Loading the data from large files into Oracle tables using SQL*Loader, PL/SQL.
• Error Handling, Package Logging and Configuration of packages.
• Developed auto generated system using SQL Server Agent to schedule the packages.
• Designed, reviewed, and created primary database objects like views, indexes, tables, stored procedures and functions.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
• Transferred data from various data sources/business systems including MS Excel, Flat Files etc. to SQL Server using SSIS various features like multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.
• Installed SQL Server 2005, 2008 and Management tools using SQL Server Setup Program.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases
• Write T-SQL Procedures using temp tables, cursors, sub queries and functions, User Defined Functions, Triggers, Views, T-SQL Scripting for complex business logic. Used multiple join statements to retrieve and update data.
• Optimize the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques.
• Successfully used Import and export wizard to move data from excel sheet to table in SQL Server Management Studio. Update and load data in the tables, remove duplicates in the excel sheets before moving data into the table.
• Designed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files.
• Involved in Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.

Environment:MS SQL Server 2008R2/2008/2005, MS SQL Server Management Studio, Query Analyzer,ETL, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), T-SQL, Microsoft Visual Studio.