PROFESSIONAL SUMMARY:

• A passionate IT leader with in depth understanding of business functions in the global Insurance financial services arena combined with innovative technical skills to lead, drive and implement projects. A proven track record of leading program level implementations with full utilization of development skills, while driving productivity and less time to business. A team player with excellent communication skills to establish enduring relationships with business partners and clients and help strengthen the long term strategic vision of the company. Experience in Data Analysis, Design, Development, Testing, Implementation and Production Support of ETL and Reporting applications.
• Extensive experience working with Business Partners (Internal and External) for requirement gathering, data review and conducting JAD Sessions for soultioning developments
• Extensive knoweldge on using Reporting Platforms, SQL Server, Tableau (Cloud Based Reporting).
• An individual with exstenive hands on development expertise in T - SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS Access, Oracle to MS SQL Server by using Talend and DTS/SSIS services.
• Experience in performing Data Conversion, Data Scrubbing, and Data Transformations with SSIS Packages and stored Procedures.
• Strong working experience of Data Warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema), OLAP and Database performance tuning.
• Experience in design and implement processes for Deploying, Upgrading, Managing, and extracting data for reporting using SQL Server Objects.
• Experience in data normalization and data modeling using Erwin and Visio.
• Having good knowledge of entire phases of Software Development Life Cycle SDLC .
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS:

SQL Server Tools: MS SQL Server 2012, 2008, 2005, 2000,7.0, Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DDL, DML, Stored Procedures, UDF, Triggers, DTS, Database Tuning Wizard, SSIS, SSAS, SSRS.

Project Tool: Visio, MS Project, Quality Center

ETL Tools: SSIS, Talend

Data Migration: MSDTS, SSIS, BCP, Data Migration, Import/Export Wizard.

Data Modeling: Erwin 4.x, MS Visio 2014/2003, Oracle SQL Developer Data Modeler

Reporting Tools: SQL Server 2012/2005 Reporting Services, Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Analyst/ Programmer

Responsibilities:

• Responsibilities include tracking, resolving day today IpSoft Tickets
• Developing reports. Implementing processes to schedule repots for business users
• Migrating 2008 Sql server, SSIS to 2012 Sql server and Ssis
• Implementation of new ETL tool Talend.
• Worked towards using Talend Job scheduler TAC . cutting down work load in control M
• Define and manage requirements and allocations, project plans, including definition of roles, responsibilities and milestones and improving quality, and ensuring “best practice” development techniques and strategies while monitoring project risk (RAIDs).
• Lead projects through SDLC, compliance and regulatory processes For actuaries, Risk control, billing and underwriting.
• Agile model
• Lead development of Underwriting Management Guide Wire into Repository Insurance Data. A Type 2 Hybrid SCD.
• Designed and defined ETL Framework to use Talend template to ensure Logging, Audit and reconciliation were always developed in all ETL.
• Sole developer in designing Error Handling.Callimg SSIS Packages from Talend using Command Line
• Developed a Job to run as a Adhoc Reporting. Where users can submit any query, and excel or csv report will be emailed to users.
• Lead SSIS ETL developer in migration from Policy Decision to Guide wire.
• Identified and Addressed major ETL issue with utilizing excels sources by defining use using interops assemblies.
• Involved designing datamart for external reporting.
• Took lead to performance tune existing process and redesign processes accordingly to gain performance
• Expertise in Complex query writing using, CTE, Rank Analytics, Pivot and un-pivot data and using FOR XML.
• Used Serena Dimension for version control.
• Used TAC (Talend) and ControlM Job scheduler to run jobs in various environment DEV, SIT, QA, PROD & DR.

Confidential

Senior BA/SSIS Developer

Responsibilities:

• Responsibilities include leading, tracking, development, implementation and integration of multiple, complex, program level projects for domestic and global field offices
• Manage 5+ member teams, while liaising with leadership committee
• Responsible for overall IT planning and delivery to meet project deadlines, included projects are (GRID, SOLVENCYII)
• Defined all assets in scope - securities, derivatives and alternative investments
• Project lead and planned various aspects of investments IT and spanning across organizations - Investments, Finance, Enterprise Risk, Corporate Systems, 55 countries and over 300 users
• Define and manage requirements and allocations, project plans, including definition of roles, responsibilities and milestones and improving quality, and ensuring “best practice” development techniques and strategies while monitoring project risk (RAIDs).
• Lead projects through SDLC, compliance and regulatory processes for Investments, Insurance ( Solvency, IRDA)
• Lead development of Solvency on GRID Global Repository Investment Data. Grid was an Attribute-Entity Value Pair (EAV) data Model with Type 2 Hybrid SCD.
• Designed and defined ETL Framework to use dtsx template to ensure Logging, Audit and reconciliation were always developed in all ETL.
• Sole developer in designing output packages, which were producing output files of solvency data for business users. In CSV Pipe and comma delimited as well as Excel formatted.
• Lead developer for re-writing SSIS Packages to integrate Blackrock Trading platform.
• Lead SSIS ETL developer in migration from Charles River to Blackrock.
• Designed reconciliation process between Blackrock and Accounting platform.
• Well versed in utilizing many systems/platforms as Source and Destination. Oracle, Netezza, Flat Files, XML, Excel and Sharepoint.
• Identified and Addressed major ETL issue with utilizing excels sources by defining use using interops assemblies.
• Involved designing datamart for Mortgage external reporting.
• Took lead to performance tune existing process and redesign processes accordingly to gain performance
• Expertise in Complex query writing using, CTE, Rank Analytics, Pivot and un-pivot data and using FOR XML.
• Used StarTeam for version control.
• Used Tivoli Job (aka Maestro) scheduler to run jobs in various environment DEV, SIT, QA, PROD & DR.

Confidential

Data Warehouse Developer/SSIS Developer

Responsibilities:

• Involved in gathering business requirement with Business Analyst, Database architect and business users.
• Support development and implementation of Vector Warehouse. Extracting relevant data for exterminations and Inspections
• Created logical - Visio Diagram for understanding process flow based on requirement and updated existing process diagram based on enhancement.
• Created SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Involved in development of Dynamic reporting focused Pest Control, Lead Poisoning and Prevention, Food Inspection, Daycare, Operational Data Store.
• Created Stored Procedures, functions, tables for tracking the package execution process (start time, end time, load information, suspended records, status etc.)
• Created SSIS packages for Incremental Load. Using Merge statements/stored procedure.
• Created the base SSIS template package including all necessary components considering best practices like Basic Logging (both SQL Server and text file logging), configuration, connection managers, pre execution, post execution etc.
• Created approximately 35 packages including extraction from flat files fixed width, excel file, oracle, and load data to SQL server.

Confidential

MS SQL Server Developer

Responsibilities:

• Developed and designed new Datamart for email campaigns
• Created ETL packages to Load data into datawarehouse Using SSIS
• Wrote Stored Procedures, incorporating Merge statement for type II SCD.
• C# Code to purge data automatically
• Designed procedures with Dynamic SQL to truncate staging tables.
• Set up Jobs using sql server agent.
• Created HTML email templates that generated reports for business Users. Like how many Total Listening seconds a particular user listened to a particular radio station or song.
• Used Pragmatic work Force as well for sms campaigns.
• Created packages in SSIS to use web service as a source and downloaded XML files through webservice.

Confidential, CA

MS SQL Server Developer/SSIS Developer

Responsibilities:

• Support development and implementation of AUM Data Warehouse, including the integration of fixed income/equity/ Alternatives and Structured Products.
• Involved in development of Dynamic reporting focused on Fixed Products (Bonds, Time Deposits, Preferred Stock and Options)
• Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Created the base SSIS template package including all necessary components considering best practices like Basic Logging (both sql server and text file logging), configuration, connection managers, pre execution, post execution etc. This package was used as base for the development by all developers. This package was created taking into account frequently used business requirements making the development process more rapid, modular and extensible.
• Created Stored Procedures, functions, tables for tracking the package execution process (start time, end time, load information, suspended records, status etc.)
• Gathered Business requirement for the AUM workflow System to support the private Equity side of business. Worked as a lead developer for the automated workflow process using SSIS packages which implemented Business Rules to validate data, integration with Dashboard to track the status of submission, implementation of business approval process via File system process and successful loading of data to Data warehouse.
• Created approximately 30 packages including extraction from flat files, excel file, oracle, SharePoint list and load data to SQL server.
• Implemented all types of control flow and data flow transformations in packages to handle different logics.
• Created data Warehouse packages to load Slowly changing dimensions (SCD1 and SCD2) using Merge Statement as well as Upsert in SSIS (Lookup and Merge Techniques)
• Created approximately 40 SSIS packages to create Trading/Finance reports based on Security Classification (Derivatives, Equity, FX etc.) using C# scripting in Script task to handle custom formatting of excel sheets, including logo etc). All the parameters could be handled dynamically from configuration table.
• Created various stored procedures using dynamic sql, advance T- SQL techniques like Common Table Expressions, Pivoting, grouping sets, ranking functions etc.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Created purge process package to delete old files depending upon the retention period. All parameters could be handled dynamically without making any changes in package by using configuration tables.
• Used SharePoint web service to get data from SharePoint list and load to data warehouse after the data validation.
• Create XSD and XML files used by SharePoint application from the SQL server database using dynamic SQL.
• Created build scripts for code promotion to SIT/QA/PROD environments.
• Created Test cases for deployment to SIT, QA and Production Environments.
• Used Visual Source Safe on regular basis for version controlling of SSIS packages as well as various T-SQL objects.
• Created run books for whole the SSIS development for the ease of Production Support team.
• Provided 2 months of Production Support which includes maintaining and documenting communication with business users on daily basis to resolve data related issues

Environment: MS SQL Server 2008, T-SQL, SSIS, Win 2003, Win 2008 Server r2, Visual Source Safe, Microsoft visio 2007, Microsoft Project 2007

SQL Server Developer

Confidential, Stamford, CT

Responsibilities:

• Responsible for migrating development database to SQL Server 2008 from SQL server 2005
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes)from transaction System to Dimensional Model
• Migrated SSRS 2005 RDL files to SQL Server 2008 reporting services
• Involved in designing the data warehouse and core Database for the system using Star Schema including tables, Stored Procedures, Indexes.
• Implemented SSIS (ETL) to extract and transform data from Oracle RDBMS, Teradata and Flat files/CSV, SQL Server 2005 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated SQL Server Drill down, Drill through, Adhoc, Sub-Reports using SSRS to fit business requirements.
• Created VB.Net Script for Data Flow and Error Handling in Script component.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions
• Configured SQL Mail agent for sending automated alerts/email

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, BIDS, Oracle 10g, Teradata, Microsoft Visual studio 2005, Windows server 2003, IIS