SUMMARY:

• 7 years of experience in the IT industry in SQL/BI Development and Analysis with OLTP, OLAP Environments.
• Expert in Designing logical and physical data model, Data mapping, Data profiling on SQL server 2008/ 2012.
• Extensive Experience working on Normalized Databases and data modelling using PowerDesigner and Visio.
• Expertise in creating and managing DDL and DML statements and creating and managing the data dictionaries.
• Experience in creating stored procedures, views, indexes and effective user defined functions and appropriate triggers to facilitate data manipulation using T - SQL, MySql and Oracle.
• Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading.
• Involved in using Hadoop eco system, build Hiveql queries on Hive and perform calculations and data loading to build consolidate data lake. Used shell script to trigger Hiveql script and pass parameters.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experienced in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc reports and distributed reports in multiple formats using SSRS in Business intelligence development studio (BIDS).
• Expert in creating and maintaining .dtsx packages using different Data flow, containers and control flow Tasks such as for loop, for each loop, sequence container, conditional split, derived column, look up, merge, sort using ETL SSIS.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SSIS ETL tools.
• Exposure of creating cubes, dimensions, aggregations, calculation using SQL Server Analysis Service (SSAS) multidimensional and tabular models . 
• Implemented SSIS ETL data, created maintenance procedures and provided data integrity strategies
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in ETL SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.

TECHNICAL SKILLS:

Programming Languages: C#, T-SQL, PL/SQL.

Databases: SQL Server 2012 /2008, Oracle 10g/9i.

Reporting/BI: SSIS, SSRS, Crystal Reports, Tableau 9.2, Power BI, SSAS, Azure Machine Learning

IDE: SQL Server Management Studio, BIDS and Visual Studio 2013/2012/2010.

Tools & Others: SQL Agent, Profiler, TFS, SVN, JIRA

EXPERIENCE:

Confidential, White Plains, NY

SQL Developer

Responsibilities:

• Wrote T-SQL queries, stored procedures to build packages. Developed user defined functions, triggers, views based on business requirements.
• Designed database model (called: PreFab Data Model) and created the physical and logical models using Erwin and PowerDesigner and generated the data dictionaries.
• Used Linux and built Hiveql queries on big data system such as Hadoop and Hive. Create tables, views and complex calculations for business metrics and prepare reporting data
• Designed, developed and fine-tuned SQL queries on Redshift of AWS for better performance
• Profiling - used data and documentation from different sources to assess quality and completeness of data and understand data definition
• Data Mapping - used source and target field definitions to identify data mapping and document the results with calculations, filters, or any special processing needed
• Build & Test ETL - Write SQL, MySql and shell scripts and convert these to ETL process for loading target data as per the defined mappings. Test data to make sure that the data is loaded correctly
• Understood business issues, data challenges including weaknesses and recommend process improvement
• Worked with clients to make sure expectations are met. Heavily involved in direct communications with clients.
• Assisted manager to prepare weekly status updates on data processing and validation process so that issues can be identified early in the process
• Mentored the junior members on the team and help each to be able to function independently. 

Environment: SQL Server 2012, T-SQL, MySQL, PowerDesigner, Hiveql, Hadoop, Linux, MS Excel, MS Visio

Confidential, Richmond, VA

BI/Database Developer

Responsibilities:

• Involved in database design and created the physical and logical models using Erwin and generated the data dictionaries.
• Use Erwin to design schema, forward engineer to create and update scripts and make required changes 
• Wrote T-SQL queries, stored procedures to build packages. Developed user defined functions, triggers, views based on business requirements.
• Designed and wrote SSIS ETL systems for data from many disparate sources, structured and semi-structured, using transformations such as lookup, merge, derived column, data conversion and aggregates extensively.
• Created highly complex SSIS ETL automation packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi-Cast, column conversion, Fuzzy Grouping, Script Components, error handling. 
• Gathering various reporting requirement from business analysts. Translated the business requirements into workable functional and non-functional requirements.
• Developed Tableau visualizations and dashboards using Tableau Desktop. 
• Developed Tableau workbooks from multiple data sources using Data Blending. 
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Developed Drilldown reports, Drill-Through reports, Parameterized reports, and Cascading Parameterized reports using SSRS. Tested all the generated reports with some test cases in the actual application.
• Converted reports from Crystal Report with Oracle data source to SSRS report with SQL server data source, using sub-reports, interactive sorting and grouping to highly decrease report running time and increase performance.
• Developed the ETL packages with configurations and variables for connection managers for the flexibility of changing the database names and for the ease of deployment. 
• Worked with dimensional modeling with Star and Snowflake schema and created data source, data source view (DSV) and SSAS cubes based on the data warehouse using dimension tables. Developed and deployed SSAS cubes and dimensions. 
• Implemented SSIS ETL data, created maintenance procedures and provided data integrity strategies.
• Designed, developed and fine-tuned stored procedures. Tuning of T-SQL queries for better performance. 
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
• Used SVN for version controlling and assisted in documentation. 

Environment: SQL Server 2012/2008 R2, SSIS, SSAS, SSRS, T-SQL, Tableau 9.2, Crystal Report, Oracle, SVN, JIRA, MS Excel, MS Visio, Erwin & Mictosoft.NET

Confidential, Elmwood Park, NJ

SQL Developer Project: Insurance Management System

Responsibilities:

• Designed and developed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers followed testing of those database objects before deployment to the production server
• Created logins, users and configuring permissions and assigning roles to users.
• Identified, tested, and resolved performance issues of poorly running queries and performance of database itself by using Index Tuning Wizard, SQL Profiler, and Query Analyzer.
• Monitored Deadlocks in SQL server using SQL Server Profiler.
• Created Clustered and Non Clustered Indexes on tables for performance optimization.
• Created and scheduled jobs using SQL Server Agent.
• Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS. 
• Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts. 
• Created the data migration strategy for migrating the data from the DB2 legacy database.
• Created the SSIS ETL packages for loading the data to SQL server periodically from DB2 database
• Performed data cleansing using various transformation such as fuzzy look ups components in SSIS ETL and cleared duplicate data using data flow components.
• Created and Designed Data Source and Data Source Views Using SSAS 2008.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SSAS.
• Used check point, Break point and Logging in SSIS to debug and optimize package while developing them.
• Monitored and kept track of error logs from logging providers in SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments
• Designed and developed the SSIS packages to Extract the data from OLTP database transform and load the ODS.

Environment: SQL Server 2012/2008 R2, SSIS, SSAS, SSRS, T-SQL, SVN, JIRA, MS Excel, MS Visio, Erwin & Mictosoft.NET

Confidential

SQL Server Programmer

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure. Used multiple join statements to retrieve data and update the tables.
• Used SSIS ETL process to produce a Data Mart for reporting.
• Strong experience in working with BCP, SSIS (DTS, DTSX) packages for Data Integration Services.
• Wrote T-SQL queries, stored procedures to build packages. Developed user defined functions, triggers, views based on business requirements.
• Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS ETL Packages.
• Implemented ETL SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Worked with Report Builder 2.0, Report Models and Ad Hoc Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: 2008R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS, & TFS.

Confidential

Jr SQL Developer

Responsibilities:

• Designing and Developing Stored Procedures and Functions in SQL Server 2008.
• Maintained and supported the SQL Server databases as a developer helping administrator
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures
• Written Stored procedures and triggers to implement business rules
• Involved in integration of the front end with the SQL Server backend
• Used DDL and DML for writing triggers, stored procedures, and data manipulation
• Maintained disaster recovery Backup and Re-Indexing was implemented to increase the performance
• Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database
• Created documentation as required

Environment: SQL Server 2008, T-SQL, Visio, Erwin, MS-Word, Excel & VSS.