EXPERIENCE Summary:

ETL and SQL Database Developer.

• Exposed to all phases of software development life cycle SDLC including of agile methodology, enterprise reporting life cycle, migrations, change control rules, problem management and escalation procedures.
• Developing reports using SQL Server reporting services SSRS , Crystal reports, Excel, Cognos reporting tools from a variety of data sources including analysis data cubes and external databases.
• Working knowledge on Data warehouse OLAP , Snow flake Schema, Star schema, Fact Tables, Dimensions ,cubes , BI concepts and Kimball/Inman strategies
• Expert in designing and implementing enterprise level ETL strategy using SSIS 2012/2008/2008 R2/2005, MS DTS, from heterogeneous data sources.
• Expertise in Financial, Insurance, Telecommunication and Health domain.
• Microsoft Certified Technology Specialist with SQL Server 2005 Implementation Maintenance
• Experienced in Database Design, Development/Maintenance/Administration on SQL Server 2000/2005/2008/2012. Experience in designing, developing and deploying Business Intelligence solutions using SSIS 2008/2005
• Proficient in implementing business logic in SQL Server 2012/2008/2005/2000 using stored procedures, Functions, Triggers, Views, Complex queries on using T-SQL. Experienced in creating generating Ad-hoc Reports, Scheduled Reports, Data extracts for business analysis using SQL Server Reporting Services SSRS and Excel.
• Expert in performance tuning and using tools Database engine tuning advisor, SQL Profiler.
• Excellent team work spirit and capable of learning new technologies and concepts.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Lead SQL/ BI Developer

Worked in Compliance Information technology and Legal affairs team as a Senior SQL and ETL developer. Currently involved in integrating the DB2 Source systems having Compliance and Metric data and developing robust ETL solutions, feeds, processes. Some of the other applications I am currently working on are MIEC, CAC, CIDW, Active Directory applications.

Responsibilities:

• Worked with business users to understand the business needs and developed ETL process for Compliance team Data needs. Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process and create ETL Run books. Designed, built and automated new SSIS packages for the application. Added new functionality to the existing ETL/SSIS packages. Performed Analysis, ETL Unit/Integration testing and data validation on the developed SSIS Packages.
• Implemented business rules and requirements using multiple transformations like Conditional Split, Look up Transform, Derived task, Script Task and Union All.
• Implemented ETL processes, designed ETL work flows using SSIS 2008 to perform insurance products data flow to the system from heterogeneous sources like Excel, DB2, Oracle and Main Frame.
• Developed scripts/batch files/jobs for Development, QA and Production environment to run the SSIS packages as ad hoc and scheduled jobs.
• Debugging ,Fixing errors, unit testing, Removing redundant code, Improving package performances in the existing SSIS packages,
• Knowledge sharing and tutoring non ETL users on SSIS, SSMS, SQL Server Agent and Qlikview process.

Technologies: MS SQL Server /2008 R2, Visual Studio 2008, Visio, VB.Net, SSIS, DB2

Confidential

Role: Senior Analyst/BI Developer

Worked as a BI/SQL developer for Verizon .Worked in the Tax IT group in Verizon for the Operational efficiency application. The main scope of this project is migration of DTS packages, Retirement of the TAX IT legacy system to the new operational efficiency system .Standardize, code and create new SSIS/ETL process in SQL Server 2012

Responsibilities:

• Converted the Biller Compliance and Accounts payable ETL as per the new ETL template.
• Understanding the old legacy process and recreating new ETL packages for the Compliance and Audit systems.
• Worked on Migration and Conversion of DTS, 2005, 2008 SSIS ETL packages to 2012 ETL packages.
• Created new views, synonyms, store procedures, performance tune store procedures as a SQL developer.
• Added new functionality to the existing store procedures to implement the changes as per the newly designed ETL framework
• Added Custom ETL components to the existing template to fit the new framework design.
• Develop Store Procedures and Views for ETL requirements and Data analysis.
• Implemented business logic using T-SQL programming and new features SQL Server 2012

Technologies: C , VB.Net, MS SQL Server 2012/2008 R2, Visual Studio 2008, 2012

Confidential

Role: Senior SQL /BI Developer

• Working as a BI developer for Thomasnet publishing .Thomas net is one of the leading publishers and providers for providing supplier information, product discovery, manufacturing company profiler information.
• Worked on Weblogs ETL and Qlikview reporting applications.
• Enhancing the current weblog ETL processes using SSIS.
• Proving SQL support for report extracts using Qlikview reporting application.
• Worked on the cluster failover and server maintenance process for ETL Process.
• Developed batch scripts to run the SSIS packages via windows scheduler.
• Provide ETL and Production support for the ETL jobs being run Daily, Weekly and Monthly.
• Developing Store Procedures and Views for reporting requirements and Data analysis.
• Documenting the ETL processes for all the SSIS packages.

Technologies: MS SQL Server 2008/2008 R2, Visual Studio 2008, SSIS, Qlikview, Windows Scheduler

Confidential

Role: Senior SQL/ BI Developer

Worked in the RRAM Group Research, Reporting, Analysis and Modeling Group in the Institutional line of business as a Senior SQL and ETL developer. Developed ETL solutions, feeds, processes for the data solutions team for their research, data mining, data ware house and analysis applications.

Responsibilities:

• Worked with business users to understand the business needs and developed ETL process for their research, modeling and analysis requirements on multiple projects like UIS, Vision, CAS, SSA and CBF. Worked on multi-terabyte relational Databases and data marts. Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process. Designed, built and automated SSIS packages for the initial load and Incremental loads. Built and created configuration files for SSIS packages to make them portable from server to server. Created Report Extracts as per business interface documents and developed ftp process for Source files.
• Implemented ETL processes, designed ETL work flows using SSIS 2008 to perform insurance products data flow to the system from heterogeneous sources like Excel, Flat files, XML, DB2,Oracle and Main Frame.
• Developed scripts/batch files/jobs for Development, QA and Production environment to run the SSIS packages as ad hoc and scheduled jobs.

Technologies: MS SQL Server 2005/2008/2008 R2, Visual Studio 2008, Oracle SSIS, DB2, Cognos. NET

Confidential

SQL SERVER/ETL Developer

IMIS IDW is used to maintain the data containing the information regarding sales, compensation, financials, organizational information into a single repository for reporting against any and all of this information.GME application is a hierarchical based approval system which is used to report/track any event.

Responsibilities:

• Enhanced the application functionality, implemented the changes as per requirement. Designed, developed and debugged Stored Procedures, User Defined Functions, and Views. Designed, created, configured, scheduled SSIS Packages from different sources like Flat Files, Dat Files, CSV Files and Excel Files in different environments.
• Developing reports using SQL Server reporting services SSRS , COGNOS basic reports from a variety of data sources including analysis data cubes and external databases.
• Deployed and scheduled SSIS jobs using Sql server agent.
• Coordinating with the front-end .NET team and Share Point team to fix the user reported issues.

Technologies: SQL Server 2000/2005/2008, SSIS, SSRS, COGNOS, .NET, SHAREPOINT

Confidential

SQL Analyst/Developer

Worked on the PIN project module of financial application. The scope of the project is loading data for new CA accounts, creating database objects and building new tables /packages as per the template.

Responsibilities:

• Wrote store procedures and queries for the existing and new Custodial Agents.
• Developed SSIS packages to format the incoming text files and to further develop the monthly statement files. Migrated all Data Transformation Services DTS Packages to SQL Server Integration Services SSIS and modified the packages accordingly.
• Migrated data from legacy system text based files, Excel spreadsheets, and Access to SQL Server 2005 databases using SQL Server Integration Services SSIS

Technologies: SQL SERVER 2005/SSIS/SSRS, cold fusion, Net, Share Point 2007

Confidential

SQL Server /ETL Developer

Worked on the Delta/CWS application. The CWS Data warehouse maintains as their Central Repository for the entire financial, security data. My responsibilities included Data migration from different heterogeneous system to Sql Server Database and building business intelligence reporting.

Responsibilities:

• Worked on the Data warehouse module of the project as a developer on MS SQL Server 2005/2000.
• Actively involved in designing and developing the data migration modules delta, cws that migrates data using SSIS packages containing tasks and transformations.
• Developed SSIS Packages using excel, OLEDB, flat files as sources to load the data in the target databases.
• Developed stored procedures for Batch Processing, to ensure data consistency on database tables, reduced the process execution time
• Developed Report Models as per the requirements and generated Ad hoc Reports using SQL Server Reporting Services SSRS .

Technologies: SQL Server 2005/2000,.NET, MS Integration Services SSIS , SSRS, Crystal reports

Confidential

SQL Server Developer

State Street is one of the largest diversified financial service organizations in the US. Its major businesses include Regional Community Banking, Fixed Income, and Corporate Banking, Private Banking, Mortgage Banking, Asset Management and Mutual fund servicing.

Responsibilities:

• Developed ETL process BCP and DTS applications from source to destination database.
• Created end of the day and intraday reports for users daily using the reporting tools.
• Developed Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins.
• Extensively worked with FTP file transfer protocol for transmitting and receiving file from vendors and clients.

Technologies: SQL Server 2000/2005, DTS, FTP, Sybase, UNIX

Confidential

SQL Server Developer

• HRMS is an integrated Human Resource Management System designed to handle the human resource activities for the organization. Responsibilities:
• Created and Modified Stored Procedures, Views, tables and Queries as developer
• Worked on MS SQL Server tasks such as data loading, batch jobs, DTS.
• Created DTS Packages to import and export data from SQL Server to Text and Excel files.
• Documentation of the entire system flow and guidance points for using the application

Technologies: MS Sql Server 2000,T-SQL, Windows 2000

Confidential

SQL Server Developer

Worked as a SQL Server developer on Supply and Distribution module of the project. Maintaining data in SQL Server database, analysis, requirement gathering were some of the responsibilities.