SUMMARY:

• More than 8 + years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2008/2008 R 2/2012/2016.
• Expert in analyzing, designing, developing, installing, and configuring Business Intelligence on MSSQL Server suite.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins to generate Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points & Logging.
• Proficient in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experienced in importing/exporting data between different RDMS in one hand and file formats like Access/Excel/CSV on the other hand using SSIS/DTSX utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in writing parameterized queries, drill through reports & formatted Reports in SSRS 2012/2014/2017 using data from ETL Loads, SSAS Cubes & heterogeneous data sources.
• Defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures
• Worked with report manager for deploying the reports across all the environments.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2012/2014/2017.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies
• Moreover, I have skills in statistical data analysis and proficient in statistical tools such as SPSS, STATA, and EpiInfo that are critical to statistical data analysis. Moreover, I am self-motivated.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2012/2014/2017 with strong analytical and problem-solving skills

BIDS/SSDT: Informatica 9.6 PowerCenter/SQL Server Integration Services (SSIS)

Data modeling tools: Oracle SQL developer data modeler, Erwin Data Modeler ER/Studio

Visualization tools: SQL Server Reporting Services (SSRS), Power BI desktop;

Source Control tools: Team Foundation Server (TFS) and Github

Project management tools: Jira, Rally/CA

Communication/sharing tools: Trello, Slack, TeamViewer, Webex Meet, FTP server

PROFESSIONAL EXPERIENCE:

Confidential - Montpelier, VT

SSIS ETL / BI Developer

• Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure. Engaged in business requirement gathering with Business Analysist and sought clarifications on functional/nonfunctional requirements for better understanding of requirements.
• Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.
• Documented ETL data mappings, data dictionaries, processes, programs and solutions as per established standard
• Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.
• Design/Prepare the LLD detailed design documents based on HLD and briefing from Module Lead Seek inputs from the developers on specific modules as applicable
• Consolidate all modules and provide to Module Lead Architects Designers for review Suggest changes in design on technical grounds Develop components inventory for the code to be developed tying it to the nonfunctional requirements Perform sampling of data to understand the character quality of the data project dependent in the absence of data analyst or designer
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Used most of controls and features in SSIS to transform data from multiple data sources like Oracle, DB2, Flat Files and MS Excel; for building tabular model/dimensional cube etc.
• Developed, monitored, deployed, scheduled and executed SSIS packages on SQL Server Agent.
• Conducted database management, performance measurement and performance tuning for existing and new databases using SQL Extended Events, Database Engine Tuning Advisor and Index Tuning Wizard;
• Created Star and Snowflake Schemas and SSAS cubes with multiple fact measure groups and multi-dimensional hierarchies based on the OLAP reporting needs;
• Well experienced in Extracting data from different sources via FTP server using ‘SSIS FTP Task’;
• Developing compelling and interactive analysis reports and dashboards for Credit Card Marketing analytics using advanced DAX.
• Integrated custom visuals based on business requirements using power BI desktop hosted on Power BI Report Server Services.
• Created ad-hoc, tabular and matrix reports, dashboards, and parameterized reports according to business requirements and converted all operational excel report into Power BI Reports.
• I have written ad hoc queries on SQL server to achieve some tasks as required by immediate supervisor.

Environment: Visual studio, SQL Management Studio, Visio, Agile, SSRS, Power BI

Confidential

SQL /ETL Developer

• Gathered and documented business requirements, definitions and designs of data sources, data flows and data quality analysis, and worked in conjunction with the data warehouse architect on the development of relational database (conceptual, logical, and physical data models);
• Created complex Tables, Indexes, Views, Triggers, Stored Procedures, cursors, functions, and SQL joins for applications.
• Created Star Schema multi-dimensional data warehouse with multiple fact measure groups and hierarchies based on the OLAP reporting needs;
• Developed, deployed, scheduled, executed and monitored SSIS packages on SQL Server Agent to extract, validate and load data from multiple sources; used Foreach Loop and Sequence Containers, extracted and loaded data applying different transformations like Derived Columns, Conditional Split, Aggregate, Sort, Merge Join, and Union all transformations;
• Optimized stored procedures and long running queries using indexing strategies and query-optimization techniques;
• Used most of controls and features in SSIS to transform data from multiple data sources like Oracle, DB2, Flat Files and MS Excel;
• Designed ad-hoc reports, dashboards, tabular and matrix reports, and parameterized reports according to business requirement;
• Created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also automated deployment for SSRS reports for all the environments.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Actively supported business users for change requests and provide support to team members by troubleshooting and solving the issues.
• Designed dynamic processing through PL/SQL for projects and also created SQL database packages and procedures

Environment: Visual studio, Management Studio, Agile

Confidential

Grant Manager/SQL Data Modeler

• Worked closely with clients to gather project requirements during the blueprint phase and to resolve issues during the User acceptance and post go-live phases.
• Translates functional and technical requirements into detailed design;
• Used Oracle SQL data Modeler to design logical, conceptual, and physical database;
• Provides data design/data movement services to help develop solutions that improve overall quality of data and support enterprise data strategies.
• Applying the data warehouse concepts, normalization principles in the design and development of start/snowflake schema data modeling.
• Coordinating with the peers on the start and end points relating to the APIs that connect ultimately at the end of life cycle for a process.
• Create and document the processes on forward engineering, reverse engineering, and complete compare as required. Ensuring the data integrity principles (Entity Integrity, Domain Integrity and Referential Integrity) are followed as necessary.
• Work on to ensure the smooth transition of work between Test, Development and Production environments, debug issues as and when arise.