SUMMARY

• Over 5 Years of experience in IT Professional career in Database, ETL, Business Intelligence and Data warehousing. Extensively worked on MS SQL Server 2019/2 MSBI Technologies(SSIS, SSAS and SSRS), C# and .NET. Expertise in various phases of project life cycles (Design, Analysing, Implementation and testing).
• Highly experienced in software development life cycle, business requirement analysis, design, programming, database design,data warehousing and business intelligenceconcepts,Star Schema and Snowflake Schema methodologies.
• Experienced working in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of seven days) called "sprints".
• Well versed in Data Modelling, Design, Development, Implementation & Administration of Database systems using MSSQL 2019/2 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS).
• Proficient in programming complex queries using stored procedures, Triggers, Cursors, User Defined Functions usingT - SQL to handle complex business scenarios
• Experienced in creating complexT-SQL queriesfor data analysis and data manipulation. Organize analytical data, ensure data quality though data profiling, and aggregate data for strategic reporting, performance optimization on database solutions.
• Experienced in writing Complex-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries.
• Experienced in programming complex TSQL Queries involving various tables using Inner and outer joins.
• Expertise in optimizing the queries by creating Index views, clustered and non-clustered indexed views.
• Excellent knowledge of Data Marts, Data warehousing, OLTP, OLAP, Physical & Logical Data Modelling, Multi-Dimensional Modelling, Star Schema Modelling, Snow-Flake Modelling, DSV diagrams, Fact and Dimensions Tables.
• Experienced in design and development of SSISpackages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join.
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Programmed SSIS packages to transfer data fromOLTP to OLAPDatabases with different types of control flow tasks, data flow transformations and deploying the packages to Production server.
• Experience inperformance tuning of SSIS packages, Query optimizationand database consistency checks. Very good skills of documenting different kinds ofmetadata.
• Involved in understanding of business processes,grain identification, identification of dimensions and measures forOLAPapplications. Created slowly Changing dimensions(SCD)and optimized fact table inserts.
• Experienced in Designing, Developing, and processing of cubes usingSSAS. Created and Configured Data Sources and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s, Hierarchies and calculated measures forOLAPcubes.
• Worked with Multi-Dimensional Expression (MDX) for querying and manipulating the multidimensional data stored inOLAPcubes.
• Experience in the Reports generation by using Authoring and Managing Components of SSRS from both relational databases andOLAP Cubes.
• Experience in generating on-demand and scheduled reports for business analysis using SQL Server Reporting Services(SSRS).Developed Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
• Expert in Automation of the ETL jobs using SQL Server Agent Job to run on a daily schedule.
• Experience in creating test data and unit test cases. Writing test cases and system plans to ensure successful data loading process.
• Experience in usingTeam Foundation Server(TFS) as a tool for source control, data collection, reporting and project tracking.
• Having excellentcommunication, Presentation skills, and Strong analytical and problem solving skills.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, SQL Profiler, Query Analyzer, Visual Studio

ETL Tools: SQL Server Integration Service (SSIS) 2017/2016/2014/2012

Data mining tools: SQL Server Analysis Service (SSAS) 2017/2016/2014/2012

Reporting Tools: SQL Server Reporting Service (SSRS) 2017/2016/2014/2012 , Microsoft Power BI, MS-Access, MS-Excel, Report Server

Programming Tools: T-SQL, C#, C++

Web Technologies: HTML, DHTML, Java Script

Operating Systems: Windows Server 2019/2016/2012 R2/2012, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, Microsoft Visio), ERWIN, Oracle-SQL Data modeler, Amazon Web service AWS

PROFESSIONAL EXPERIENCE

SQL/SSIS/SSRS Developer

Confidential, Rockville, MD

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.
• Involved in the analysis, design, development, testing, deployment, and user training of analytical and transactional reporting system
• Worked on project management including project plans and estimates, scoping and requirements through implementation, Requirement Gathering, Requirement analysis, Application environment Setup, Preparing Test Scripts, Project Status reporting, bug fixing and deployment.
• Contributed to programming complex T-SQL queries and Stored Procedures for generating reports and various business logic / scenarios.
• Developed new stored procedures and triggers, modified existing ones, and tuned them to achieve optimum performance using execution plans and trace files.
• Responsible to monitor performance and optimize SQL queries for maximizing efficiency
• Designed, developed, deployed, and tested the ETL workflow to load data from source to staging and Data Warehouse through Microsoft ETL SSIS.
• Used change data capture CDC to simplify ETL in data warehouse applications.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Worked on managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Designed, developed, and deployed OLAP cubes and SSIS packages to process OLAP cubes through source views having dimension and fact tables listed. Utilized XMLA file for deployment of cube.
• Conducting a meeting with BSA to gathering more information on workflow for data migration and to understand new terminology for new application.
• Documenting allETLprojects and workflows by usingBi Documenterand also including supporting documents for troubleshoot for each project.
• Created SQL server configurations for SSIS packages and experienced increating jobs, alerts, and SQL mail agent and schedule SSIS packages.

SQL/ETL Developer

Confidential, Gwynn Oak, MD

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Translated requirements, designs and functional specs into use case document, test plans and test cases documents.
• Prepared use cases and class diagrams using UML. Designed Database using Lucid Chart.
• Actively participated in daily calls with Client and Client Team.
• Designed, developed, and delivered business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used indexes to enhance the performance of individual queries and enhance the stored Procedures.
• Involved in programming and solving the issues in the complex SQL statements and performing the query optimization.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase). Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Contributed to creating complex SSIS packages using proper control and data flow elements. Worked with different methods of logging in SSIS.
• Responsible for ETL support operation using SQL Server Integration Services (SSIS) and worked with users to train and support
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Applied Multithreading techniques for creating high performance applications.
• Developed scripts for Exception handling for each SSIS packages.
• Used Script component to derive error description from the metadata.
• Extensively worked withSSIStool suite, design and created mappings using various SSIS transformations like OLEDB Command, Conditional Split,Lookup, Aggregator,Multicastand Derived Column.
• Prepared different types of reports like parameterized, Drill down, Drill through, Sub-reports using SSRS
• Validated/Tested to ensure correct application of transformation logic from source to target.
• Automation of the ETL jobs using SQL Server Agent Job to run on a daily schedule.
• Setup email notifications in case of job failure in SQL Server Agent.
• Planned, Defined and Designed data based on business requirement and provided documentation.

Jr. SQL Developer

Confidential, Sanford, NC

Responsibilities:

• Responsible for gathering business requirements to create custom business user reports using excel.
• Developed, implemented, and maintained various database objects suchas stored procedures, triggers, functions, indexes, and views.
• Developed and maintained ETL packages to extract the data from various sources and Responsible fordebugging and upgrading of several ETL structuresas per the requirements.
• Used SSIS and T-SQL stored procedures to transfer data fromOLTP databases to staging areaand finally transfer into data warehouse.
• Created logging forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Supported installation/upgrades of Third-Party Software.
• Earned knowledge of financial instruments such as making payments to the account after splitting them to the accounts based on the commission rates and the bucket levels.
• Used TFS to store, run, view, edit and revert to different versions of the design in case of a version control.