SUMMARY:

• 3 + years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2012/2008R2 system in OLTP and OLAP environment.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R2.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R 2/2008/ 2005.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high-pressure environment.

TECHNICAL SKILLS:

• MS-SQL Server 2012/2008R2
• SQL Server BI Development Studio (BIDS)
• MS Visual Studio 2010,2013,2015
• SQL Server Integration Services (SSIS) 2012/2008R2
• SQL Server Reporting Services (SSRS) 2012/2008R2
• Oracle
• T-SQL
• POWER BI
• Trello (project management tools)
• Slack (project management tools

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL /SSIS/SSRS Developer

Responsibilities:

• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and scheduled jobs for various tasks also was responsible for maintaining jobs through SQL Server Agent.
• Designed SSIS packages for loading data from ODS to Data mart.
• Extracting, importing, and exporting of data in various database applications
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.

Tools: SQL Server 2008R/2012/2014, Visual Studio 2010/2013/2015, Power BI, Oracle Data Modeler, Trello

Confidential, CT

SQL/SSIS/SSRS Developer ETL

Responsibilities:

• Responsible for creating logical and physical model using ERWIN.
• Built a package to transfer data between OLTP and DW databases.
• Created Views to reduce database complexities for the end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

Tools: SQL Server 2008R/2012/2014, Visual Studio 2010/2013/2015, Power BI, Oracle Data Modeler.