SUMMARY:

• Around 8years of in - depth experience in database design, development, maintenance,Analysis, Validation and testing of SQL Server 2012/ 2008 / 2005 / 2000 large scale databases for both OLTP and Data Warehousing System applications such asSSIS, SSAS, and SSRS in Financial, Technology, Education and Health Insurance domains.
• In depth Knowledge of the federal regulatory frameworks in the banking sector to identify regulatory risks and reporting requirements and gaps for Example Asset and Liability Management(ALM) and Comprehensive Capital Analysis and Review (CCAR).
• Interacted extensively with client teams to understand various data fields and created Source to target data mapping documents which enable easy identification of key data element and helped users to have a clear explanation of data elements used in reports.
• Experience in leading small development teams, acting as a scrum master and leading agile development.
• Experience in providing requirements to Big four consulting firms (EY) hired by the client.
• Experience in creating data models and DataMart’s based on user requirements and available data fields.
• Hands on experience in developing and writing T-SQL queries, store procedures, triggers, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2005/2008 and MS SQL Server 2005/2008 respectively.
• Good command in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2012/2008 (SSRS).
• Accomplished in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012/2008.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Working knowledge with PowerBI is a plus
• Knowledge of migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2008.
• Experience of Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.

TECHNICAL SKILLS:

• MS SQL Server 2000/2005/2008/2012
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• Data Stage
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• MYSQL 5.5
• 5.6 and 5.7
• Rational Rose
• Oracle 9i
• TOAD 6.0
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML
• C++
• JavaScript
• SharePoint
• Unix ODBC
• MS Visio 2008.

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

ETL Developer

Responsibilities:

• Design Develop and test the ALM (Asset and Liability Management) data model, capital reports and FED Regulatory Submissions.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to DW
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed the SSIS packages using different kind of data flow transformations like Aggregations. Conditional split, derived columns, lookups, Merge join, Pivot etc.
• Create statistical data models to be used as tools in the development of client portfolio strategies.
• Interact with client team to understand federal reporting requirements of bank, created data warehouse and ETL procedures to automate the reporting processes. Reporting processes were automated for different entities of the client and various federal reporting requirements such as CCAR, ALM
• Interacted extensively with client teams to understand various data fields and created Source to target data mapping documents which enable easy identification of key data element and helped users to have a clear explanation of data elements used in reports.
• Used data mapping exercise to do Gap Analysis for identifying data elements required for federal reporting.
• Perform detail analysis of data and create ALM schedules for loans and non-loans.
• Lead the UAT team for ALM Data model and handled multiple releases during this process
• Defect triaging using JIRA
• Created a Data flow diagrams to explain the users the data flow in creating financial reports.
• Implemented the submissions of CCAR FRY 14Q and CCAR FRY 14M Submissions.
• Implemented Edit checks to the client for submissions which helped them for validate the date.
• Perform End to End reconciliation for FED submissions using Y9C data.
• Implemented Testing, development and Production environments for the reporting applications.
• On - boarding a new bank data into our system by normalizing banks data and its historical validation
• Provide banks with market share, customer preference, marketing strategies and new product introduction using customized reports and financial analysis.
• Write complex T-SQL queries, procedures, and views, cursors to aggregate and summarize the data as required for reports.
• Assisted in developing a holistic data model for an issuer that covers around 3000 fields in various domains like Credit cards, Mortgage, Home equity, Commercial and other loans. The model covers the need of the operations, ALM/FRY-14 reporting and other risk analytics to be performed at a customer, account, and transaction and application level.
• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.Participation in Performance tuning in database side, transformations, and jobs level
• Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system T-SQL Server database (SSIS).

MS BI Developer

Responsibilities:

• Developed and deployed the SSIS packages using different kind of data flow transformations like Aggregations. Conditional split, derived columns, lookups, Merge join, Pivot etc.
• Created the database objects like tables, store procedures, triggers, indexes Etc using T-SQL to provide structure to the store data and to maintain database efficiently.
• And scheduled the jobs for packages and store procedure, Maintained the jobs on daily basis.
• Responsible for implementation of data viewers, SSIS logging, error configurations for error handling the packages.
• Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database(SSIS).
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizingthem.
• Setup database maintenance plans and used index tuning wizard to reorganize indexes, re-indexing and update the index statistics on the production databases.

MS BI Developer

Responsibilities:

• Analysis and requirement gathering for SRS document.
• Requirement gathering from client.
• Created Cosmos scripts to extract data from log files.
• Developed and Deployed SSIS Packages using different type of transformation and also maintain the jobs running in the server.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Writing stored procedures. Maintenance of data ware house and checking of jobs.
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Used to develop the reports by using SSRS and Power Pivot.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• Making new data pipelines from cosmos to DB and scheduling

MS SQL Server Developer/BI Developer

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to DW
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed data transfer packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple TSQL.
• Used to develop the reports by using SSRS and Power Pivot.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics,Tableau Reports using SSRS
• Designed and developed Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Proficiency in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes,
• Data MiningModels, Deploying and Processing SSAS objects, and writing MDX queries.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.

MS SQL Server Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.