SUMMARY

• 10 Years of experience in SQL Server Development (2014, 2012, 2008, 2005) including writing SQL Programming, SSIS, SSRS, SSAS and Tableau
• Certified in Microsoft SQL Server 2008 Implementation and Maintenance
• Experienced in creating Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, Cursors and Indexes, Derived Tables using SQL programming to facilitate efficient data manipulation and data consistency.
• Good knowledge in Data Warehouse concepts and ETL process.
• Good knowledge in Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Primary Keys and Foreign Keys.
• Experience in Extracting, Transforming and Loading (ETL) data from Flat File, XML and any SQL Data Source to Excel, Flat File, MS SQL Server Destinations by using SSIS services.
• Expertise in Creating, Deploying and managing SSIS package.
• Monitored and Optimized SSIS package performance to reach the expected time frame for data loading.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Developed and tested trades coming from TMS Monito applications (Murex) under Credit Risk Management after Risk Analysis.
• Experience in Microsoft Visual C# in script component of SSIS.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Design and Developing Automated UNIX Shell scripting for loading, running the mappings and validating the data in the data warehousing system.
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports in SSRS.
• Developed dynamic drill-down, drill-through and sub reports in SSRS.
• Created data visualization using Tableau.
• Experience in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Creating dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies using Tableau.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Exposure in data modelling using Erwin and ER Studio in several projects in both OLAP and OLTP applications
• Experience in data mining and data modelling for collecting, cleansing and analyzing structured and unstructured data for major project initiatives.
• Comprehensive knowledge and experience in process improvement, data extraction, data cleansing, data manipulation.
• Used ASP .Net with C# for creating web application.
• Experience in Preparing Dashboards and building complex formulas in Tableau for various business calculations
• Knowledge of Transact-SQL (DDL, DML, DCL, Merge statements), Design and normalization of the database tables and Relational Database Management Systems.
• Designed, developed, implemented and supported numerous projects in various capacities as a part of team and as the primary client contact/lead developer
• Possess strong critical reasoning, problem solving, analytical and conflict resolution skills
• Highly competent in gathering, understanding and analyzing user requirements and converting them into software requirement specifications.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Extensive testing ETL experience using SQL queries to test the application for data integrity and verified the contents of the data table
• Experience in documenting, preparing test plans, executing it and Code Review.
• Strong Analytical, Oral and written communication skills.
• Highly adaptable in quickly changing technical environments with strong organizational and analytical skills.
• A good team player with excellent time management skills having profound insight to determine priorities, schedule work and meet critical deadlines.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Perl, Unix Scripting, Windows Batch file

Databases: SQL Server 2014/2012/2008

Cloud Datawarehouse: AWS Redshift, Snowflake

On Prem Datawarehouse: Microsoft Parallel Data Warehouse(APS 2015)

Job Scheduler: BMC Control M, Windows Batch Files

Data Storage System: AWS S3

ETL Tools: SQL Server Integration Services(SSIS)

Database Tools: SQL Server Management Studio(SSMS), PL/SQL Developer, SQL Plus, TOAD

Platforms: Windows 2000/2003, Windows XP, Windows NT, Vista, Windows 10/8/7, Unix

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Designed SSIS Packages to extract, transfer, load (ETL) raw data from upstream System into Microsoft Parallel Data Warehouse(APS 2015), SDX server(Web App) and AWS Redshift(Analytical System)
• Worked on cloud POC to select optimal cloud vendor(Snowflake and AWS)
• Architecting, designing and operationalizing large-scale data and analytics solution on MPP(Microsoft APS) and Cloud System(AWS Redshift and Snowflake)
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS 2015/2014/2013 )
• Work with business user to ensure the architecture design meets the product requirements.
• Worked on Snowflake, Redshift cloud-based project and to design dynamic ETL solution to load the data from On-prem to Cloud and AWS S3 to Cloud Datawarehouse using copy command
• Extensive experience in creating parameterized procedure and writing SQL queries against Redshift and Snowflake Cloud Data warehouse.
• Experienced in designing ETL solution, data loading, Performance Tuning, Query Optimization in AWS Redshift.
• Design and development used Agile Development concept with the application being divided into modules and developed in cascading stages.
• Managing source code in Microsoft Team Foundation Server (TFS), loading data using Dwloader, BCP and SSIS.
• Production Automation: Designed ETL/ELT process for periodic automated loads (Loading files into APS tables), including FTP/SFTP file transfer to/from SQL Server to Unix

Environment: Microsoft Parallel Data Warehouse(APS 2015), AWS Redshift, Snowflake, SSIS, Control M, Microsoft TFS, SQL Server 2015

Confidential, New York, NY

SQL BI/ETL Developer

Responsibilities:

• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012/2014.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column and For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Experience in Microsoft Visual C# in script component to load Excel in SSIS packages .
• Loading heavy data into pre-stage
• Performing transformation on Pre-Stage data and loading them into ODS and DW.
• Created Databases, Tables, Stored Procedure, DDL/DML and Views using SQL programming to facilitate efficient data manipulation and data consistency
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Used Data mapping document to map the source and target columns in SSIS packages.
• Used Event Handlers to notify the User communities about the results of SSIS package execution.
• Performed data mining and data modelling to cleanse and analyze unstructured data, also test data to test business requirement functionality
• Identified the gaps in business and system requirements thereby bridging the business and technical communities together to ensure end-user objectives
• Perform unit testing at various levels of the ETL.
• Prepared Parameterized, Linked Report, drill down, drill through and sub-reports in SSRS .
• Also used Report Server Manager to create Shared DataSource, Dataset, Subscription and Caching to autogenerate the Report.

Environment: SQL Server Management Studio, SSIS, SQL, Power BI, GIT

Confidential, Weehawken, NJ

Sr. SQL BI/ETL Developer

Responsibilities:

• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012/2014.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column and For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Experience in Microsoft Visual C# in script component of SSIS.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS
• Experience in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Primary Keys and Foreign Keys.
• Created Databases, Tables, Stored Procedure, DDL/DML and Views using SQL programming to facilitate efficient data manipulation and data consistency
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Used Data mapping document to map the source and target columns in SSIS packages.
• Used Event Handlers to notify the User communities about the results of SSIS package execution.
• Performed data mining and data modelling to cleanse and analyze unstructured data, also test data to test business requirement functionality
• Identified the gaps in business and system requirements thereby bridging the business and technical communities together to ensure end-user objectives
• Perform unit testing at various levels of the ETL.
• Prepared Parameterized, Linked Report, drill down, drill through and sub-reports in SSRS .
• Also used Report Server Manager to create Shared DataSource, Dataset, Subscription and Caching to autogenerate the Report.

Environment: SQL Server Management Studio, Toad 12.0, SSIS, SQL, MS Excel, JIRA, Tableau

Confidential, Wilmington, DE

SQL BI/ETL Developer

Responsibilities:

• Created dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Worked extensively with Advance Analysis Actions , Calculations , Parameters , Background images , Maps.
• Experience in creating filters, quick filters, data source filters, local & global filters, context filters and user filters.
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Experience in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Ability to translate complex data requirements into simple, understandable formats understood by both technical and non-technical users.
• Built complex formulas in Tableau for various business calculations.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Proactively and efficiently performed all tasks associated as a lead developer on multiple projects
• Involved in developing SSIS packages for extracting, transforming and loading data.
• Developing SSIS packages(DTSX) to get data from different sources like new Flat Files, SQL Server and other sources and load them into SQL Server involving data quality, data conversion, data validation, error handling and testing.
• Prepared Parameterized, Linked Report, drill down, drill through and sub-reports in SSRS .
• Actively participated in establishing development guidelines, coding standards and code review process
• Worked closely with other developers and provided assistance in solving bugs, and guiding them during all phases

Environment: SQL Server Management Studio, SSIS, SQL, Tableau, MS Excel

Confidential

ETL Developer

Responsibilities:

• Engaged in multiple projects to perform requirement gathering, analysis, estimation, solution, application design / development through maintenance, code review and unit testing.
• Developed applications using SQL Server 2005/2008, SQL Server Integration Services(SSIS), Server Reporting Services(SSRS)
• Developed reports in PDF/Excel using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS)
• Created reports (tabular, matrix, chart, drilldown reports, parameterized, cascade reports) according to business requirements.
• Created SSRS reports using TSQL queries.
• Created SSIS packages for uploading of different formats of files (Excel, flat files) and databases into the SQL Server.
• Worked on different kinds of Transformations (Data Conversion, Lookup, Derived Column, For Loop, For Each Loop, Conditional Split, Look up, Slowly Changing Dimension, Union All) in SSIS as per the clients Requirement
• Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental Historical load logic data from Source to Staging Environment and into the Enterprise Data Ware House
• Experience in Microsoft Visual C# in script component of SSIS.
• Coordinated with QA and Release management for projects and bug fixes to be released in production environment.
• Formatted the report layout for the requirement of the end users
• Identified the gaps in business and system requirements thereby bridging the business and technical communities together to ensure end-user objectives
• Written queries for backend processing in SQL Server 2005/2008
• Used ASP .Net with C# for application building.

Environment: MS SQL Server Management Studio, BIDS, SSRS, SSIS, MS Office 2007