SUMMARY:

• Over 5 years of strong experience in the IT industry as a SQL Server Developer/BI Developer in Telecom, Pharma and Health Insurance domains.
• Experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Worked on BCP (Bulk Copy), Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using SSIS/DTS, Oracle and PL/SQL
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation .
• Experience in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Excel and MS Access, CSV, flat file.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS Creating mappings/workflows to extract data from different Sources, OLEDB Sources, Flat File, EXCEL, XML, and Access etc. And Cleans Data using different Transformation and load into various Business Entities.
• Creating an OLAP cube by using the Cube and Dimension Wizards.
• Experienced with different components of SSIS (Control Flow, Data Flow and Connection Manager) while using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks.
• Experience in designing high - level ETL architecture for overall data transfer from the OLTP-Online Transaction Processing to OLAP with the help of SSIS.
• Experience in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2008.
• Experience in development of Drill down Reports in SSRS and Generated daily, weekly and monthly reports for the department managers.
• Experience in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Experience in optimizing performance of various long running queries and stored procedures using SQL Server Profiler, Database Engine Tuning Advisor.
• Experience at building and deploying multi-valued parameterized reports using Power BI.
• Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, T-SQL, DYNAMIC SQL, Teradata Macros, C#

Web Technologies: HTML, XML, ASP.NET, UML, XML.

Tools: & Utilities: TOAD, PL/SQL Developer, SQL Navigator, SQL*Developer, SQL Tools, Crystal reports, Microsoft Visual Studio, SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, DBMS SQL, DBMS Packages.

Database Tools: SQL Server Management Studio, BIDS, SSDT, SSIS (ETL), SSRS, SSAS (OLAP), Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), Bulk Insert and BCP, ODBC, Crystal reports, Teradata SQL Assistant, Teradata Manager.

Databases: SQL Server 2014/2012/2008 R2/2008, Oracle 10g/11g.

Operating Systems: Windows XP to 10, Windows Server, Linux.

EXPERIENCE:

Confidential, Norfolk, VA

SQL Server / MSBI Developer

Responsibilities:

• Gathered and documented business requirements, Security requirements, Enterprise Data Sources and External Data Feeds.
• Writing complex SQL Queries, CTEs, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Designed and developed SSIS Packages (.dtsx files) to import and export data to and from SQL Server, Oracle, MS Excel and flat files.
• Worked on ETL for Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL Job Scheduled to run daily, weekly and monthly. Solved the issues associated with ETL Data Warehouse job failures.
• Gathered Flat files from FTP server and loaded it into SQL Server.
• Supporting the existing jobs and the processes.
• Worked on performance tuning in SQL server.
• Worked with various kinds of reports for Member, Provider Relations using SSRS and published these reports
• Worked on different kinds of Transformations in SSIS and processed Loads into Staging/ODS areas.
• Worked on migrating Legacy DTS Packages (ETL) to the new SQL Server Integration Services SQL (SSIS) format.
• Designed Complex SSIS packages interfacing SQL Server with Oracle 11g.
• Performed installation and configuration of SQL Server Reporting Services (SSRS).
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Involved in designing Parameterized Reports and also cascaded Parameterized Reports.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Reporting skills using SQL Server Reporting (SSRS).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Design and development of SQL Data Model to satisfy the end user reports by creating different types of Reports and Dashboards in Power BI.
• Developed custom calculated measures using DAX in power BI to satisfy business needs.
• Migrated existing self-service reports and adhoc reports to Power BI.
• Used Team foundation server for source control and sprint planning.

Environment: SQL Server 2008 R, SQL BI Suite (SSAS, SSIS, SSRS), power BI, MS Project & Windows Server .

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Developed, monitored and deployed SSIS packages and Responsible for Scheduling Jobs, Alerting and Maintaining SSIS Packages.
• Migrated SSIS packages from SQL Server 2005/ 2008 to SQL Server 2012.
• Worked on Data migration using SSIS between SQL Server, Excel, Oracle and Flat Files.
• Worked on ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load and analyzed the project requirement and preparing the documentation for the ETL Package Flow.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like lookup, merge, merge join, script component and slowly changing dimension.
• Created Stored Procedures and handled the Query Performance Issues.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Interacted with the Business Users to analyze the Business process and gathered the requirements & provided documentation for all kinds of reports, DTS and SSIS packages.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Wrote BTEQ scripts to transform data.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata
• Wrote complex SQL queries using joins, stored procedures, and user defined functions to verify the data from the database to generate reports based on the business requirement.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Utilized SSRS reports from different source formats satisfying clients by representing reports and presentations.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports using SQL server 2008/2012 Reporting Services.
• Created reports to retrieve data using Stored Procedures, MDX Queries that accept parameters.
• Responsible for Monitoring and Tuning report performance.
• Worked on SSRS tabular reports as per the client requirements
• Customized SQL queries to create RDL Datasets and create SQL reports.
• Employed Transparent Data Encryption, a new feature of SQL Server 2008 to store the data securely by encrypting the database files.
• Created SSRS Data Model projects using Microsoft Visual Studio 2005 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users
• Involved in Installation and Configuration of MS SQL Server 2005/2008 R2/2012.
• Worked on Kimball Data Warehousing dimensional modelling.
• Tested applications behavior in QA of SQL Server 2014 environment and tested initial installation and screening of SQL server 2014 on Client environment.

Environment: MS SQL Server 2008 R2/2012, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise Manager, XML, Teradata R12/R13, Teradata SQL Assistant, TPUMP, FAST LOAD. MS PowerPoint, MS Project & Windows Server, Microsoft visual studio.

Confidential

MS SQL Server /ETL Developer

Responsibilities:

• Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Designed database, tables and views structure for the new data mart. Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server using DTS Packages.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Involved in assisting QA team in deploying and testing the applications which uses SQL server as database. Performed unit testing and SQL performance tuning.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.

Environment: MS SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, MS SQL Profiler, Crystal Reports10.

Confidential

SQL Server Developer

Responsibilities:

• Involved in the development of the back-end systems.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS 2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Created SSRS reports using report parameters, Drop-Down Parameters, and Multi-Valued Parameters.
• Involved in ER diagrams and mapping the data into database objects.
• Design of the database and tables, views, triggers, stored procedures.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.
• Built effective queries and stored procedures for high performance reporting and rendered them to HTML, PDF and EXCEL formats using reporting services.
• Wrote procedures to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to insert/update and delete data in MS SQL database tables.
• Evaluated database performance and performed maintenance duties such as tuning and backup/ restoration.
• Identifying procedures include stored procedures /triggers to speed up application
• Used ADO.NET for fetching data from SQL Server.

Environment: SQL Server 2008, T-SQL, DTS.