PROFESSIONAL SUMMARY:

• Experienced working on Agile Projects with Multiple Sprints cycles and Scrum meetings
• Experienced using Agile Project management tools like Trello and JIRA
• Hands on experience working on Water Fall Projects with full SDLC
• Expert on installing and configuring MS SQL Server 2005\2008\2008 - R2\2012
• Hands on experience in configuring Reporting Service, Report manager and Report Server
• Expert on Configuring MS SQL Integration Service Catalogs
• Extensive experience in analysis, design and development of software applications in SQL Server.
• Extensive knowledge in ER Diagram and design of logical and physical data modeling using Erwin tool and Visio.
• Extensive experience in designing de-normalized data warehouse including Star Schema, Snow Flake Schema and data flow diagrams.
• Extensive experience in creating and using Stored Procedure, Views, Triggers, schemas and Complex queries on SQL Server Management Studio.
• Extensive work experience on Common Table Expressions, Cursors, Functions, User- Defined Types and Dynamic SQL.
• In depth experience in using SQL Server Data Tool (SSDT) and business intelligence development studio (BIDs)
• Hands on experience in configuring Data Flow source and destination connection strings
• Extensive experience in implementing event driven Error handlings and package logs.
• Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.
• Hands on Experience on SSIS package development, deployment and scheduling.
• Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service.
• Hands on experience on developing Page level Reports, Dashboards, and Stories Using Microsoft Power BI.
• Extensive experience in implementing self-service reporting capabilities using SQL Server Analysis service, Power BI and Report Builder.
• Experienced in Database Optimization using SQL Profiler, Database Tuning Advisor, and windows performance monitor.
• Experienced to translate reporting and analytical needs into technical solutions.
• Strong interpersonal & communication skills, Competitive analytical, logical, and problem solving skills, Strong management, administrative and leadership skills to work in team.
• Authorized to work in the US for any employer/GC-EAD/

TECHNICAL SKILLS:

Operating System: Windows 2000/XP/7/8/10

ETL Tools: DTS, SSIS, Informatica

Reporting Tools: SSRS, Report Builder 2.0/3.0,

Databases: MS-SQL Server 2012/ 2008/2005 MS-Access

Language skills: Transact SQL (T-SQL), PL/SQL,VB,C#

Database tools: SQL Profiler, PerfMon, Database Engine Tuning Advisor, SSMS, SQL Agents

BI Tools: SSIS, Cognos,, Tableau, SSRS

EXPERIENCE:

Confidential, Washington, DC

ETL Developer / SQL Developer

Responsibilities

• Designed and Developed complex SSIS packages for performing ETL process using SQL Server Integration Services.
• Worked using integration services for transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV, Oracle, MS Access).
• Worked on Data Mapping extensively.
• Responsible for Data Profiling to determine data integrity for transformation of Data from Source to Target.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Expertise in Data Analysis, Understanding in Dimensional Data Modeling, Data Extraction, Transformation & Loading (ETL), Cubes and End User Reports.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.
• Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling and also tested the packages for Incremental Data Load & duplications.
• Proficient in Testing methodologies, Test Matrices and Trace matrix.
• Analyzed data and generated different kinds of graphs, charts using Excel .

Confidential

SQL Developer/ Data Analyst

Responsibilities

• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Export and import data from Flat file, CSV file, Excel to/from SQL Server database using SSIS.
• Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.
• Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.
• Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Created SQL server Analysis Projects; created Multidimensional databases cubes, facts and dimensions for the analysis of products in specific areas using SSAS.
• Design and Developed multiple Enterprise reports using SSRS from both OLTP and OLAP databases
• Documented and delivered Functional Specification Document to the project team by using SQL Server.
• Tested the reports and fixed bugs in the stored procedures, involved in scheduling the reports and setting security for reports.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track report history using SSRS.

Confidential, Hartford, CT

Data Analyst

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup, etc for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2012.
• Designed, developed and tested the DataStage jobs using Designer and Director based on business requirements and business rules to load data from source to target tables.
• Established best practices for DataStage jobs to ensure optimal performance, reusability, and restartability.
• Defined the report layout and identified Datasets for report generation.
• Created different type of reports including Cross-tab, Drill through, Drill-down, Sub reports, and parameterized reports.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.