SUMMARY:

• 12+ years of IT experience in requirement gathering, Analysis, Design, Development, testing, Implementation and maintenance of projects in Banking and Finance, Investment and Wealth Management, Insurance
• 5+ years of Onsite Lead experience, working directly with the LOB users and Clients.
• Extensive experience in Software Development Life Cycle, STLC, waterfall & Agile methodologies.
• Experience in creating the Business Requirement Document, High Level and Low Level Design Document.
• Extensive experience focusing on Data Integration, Data Migration, Data mining, Data profiling, ETL process and Business Intelligence for Banking & Finance, Investment & Wealth Management and Insurance
• Extensive experience in creating, configuring and deploying SSIS packages
• Experience in Database Development including effective use of Database objects, Different types of Optimizers, Indexes, Table Partitions, Materialized Views, Global Temporary tables
• Good exposure in performing data analysis using different SQL tools like Toad, SQL Teradata Assistant, DB Visualizer, Oracle SQL Developer and SSMS.
• Developed the solutions for the complex issues by analyzing the systems thoroughly and Proficient using SQL Server in constructing Tables, indexing and constraints
• Comprehensive knowledge in debugging and troubleshooting SQL, SSIS, SSRS & SSAS issues
• Experience in using Team foundation server (TFS) and SVN for migrating the server objects to another server
• Very familiar with Slowly Changing dimensions - SCD1 and SCD2 in snowflake schema and star schema
• In depth knowledge of designing the high level ETL data load for integrating data from heterogeneous sources like Excel, CSV, Oracle, flat file, SQL Server using Microsoft integration services (SSIS) and migrate to Oracle
• Good in Performance tuning and query optimization, Involved in identifying the bottlenecks at both source and target while extracting data from different sources
• Excellent experience in developing Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions using SQL Server Reporting Services (SSRS)
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data marts, ODS & Data ware house concepts
• Expert in Mainframe technologies includes Cobol, JCL, VSAM, CICS, DB2, IMSDB
• Good Knowledge in Composite - a data virtualization layer, created and deployed all the iSeries objects required for LOB users using CISCO information server.
• Experienced in working with various Python Integrated Development Environments like IDLE, PyCharm Spyder and good working knowledge in Numpy, Scipy, Matplotlib, and Pandas python libraries during development lifecycle.
• Good experience in performing various testing Unit testing, System Integration testing (SIT), Regression testing, User Acceptance testing and played a vital role in QA.

TECHNICAL SKILLS:

Technical Tools: Microsoft Visual Studio Data tools, Business Intelligence Development Studio, Informatica, Microsoft Team Foundation Server, Tortoise SVN

BI Tools: SQL, SSIS, SSRS, SSAS, Tableau, Excels

Databases: MS SQL Server 2008 R2/2012/2014, DB2, IMSDB. Oracle 10g/9i

Programming Languages: C, C#,T-SQL, COBOL, JCL, CICS, VSAM, SPUFI, Endeavor, QMF, FILE-AID

Operating Systems: z/OS, Windows, IBM OS/390

Data Access Tools: Teradata SQL Assistant, Oracle SQL Developer, TOAD, DBVisualiser

Other Skills: Python IDE, PyCharm, Spyder, Python Libraries Pandas, Numpy, ScipyHadoop HDFS, HIVE.

PROFESSIONAL EXPERIENCE:

Confidential, TX

Senior Software Developer

Responsibilities:

• Involved in Requirement gathering, analysis of Business and Functional requirements
• Thorough analysis of oracle Pulse system including all application and migration oracle packages
• Created many Stored Procedures and SQL queries and Defined DDL’s for data loading, have written many scripts using C# in Script task transformation for validating the data, sending emails regarding the status and results
• Expert in Extracting and Transforming data from various heterogeneous sources and creating packages using SSIS, Import and Export wizard for moving data from Excel to SQL Server, Bulk Insert and BCP utilities.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Script task and Send Mail task, Execute SQL Task, Data Flow Task to export cleaned data from Excel Spreadsheets, Text file and CSV files to SQL server database
• Skilled in error and event handling: precedence Constraints, Check points, Event Handlers and Logging.
• Created many Sequence & For each loop containers and performed serial and parallel extraction to load the data from various sources to oracle database
• Involved in SQL performance tuning and followed optimization techniques for better efficiency
• Extensively Worked in Oracle stored procedures, views, triggers, packages using Oracle SQL Developer, have modified many stored procedures/packages as per the business requirements.
• Good working knowledge in Oracle database 11g, T-SQL, DDL, DML, DCL Cursors, Constraints, indexes, error and exceptional handling

Environment: SQL Server 2008 R2/12/14, SSIS, SSRS, Oracle 11g, T-SQL, AWS

Confidential, Addison, TX

Responsibilities:

• Involved in Requirement gathering, designing, developing and deploying reports in MS SQL Server environment
• Developed SSIS Packages for extracting, cleaning, transforming and loading data into data base
• Extensively worked on Views, Created many Stored Procedures and SQL queries and Defined DDL’s for data loading, have written many scripts using C# in Script task transformation for validating the files
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task, Execute SQL Task, Data Flow Task to export cleaned data from Excel Spreadsheets, Text file and CSV files to SQL server database
• Expert in Extracting and Transforming data from various heterogeneous sources and creating packages using SSIS, Import and Export wizard for moving data from Excel to SQL Server, Bulk Insert and BCP utilities.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Created reusable transformation and performed serial and parallel extraction process to load the data from various sources to data marts
• Performing Code reviews and testing the ETL code, unit testing, System Integration testing, Regression testing
• Have written many stored procedures for doing the data validation and database testing both at source and target side.
• Creating Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Ad-hoc reports according to business requirements in using SSRS
• Good knowledge in composite- Cisco Information server studio 7.0 which is used to deploy all the requested iSeries files/objects.
• Created the Summary and detail reports for different executives and shared them through Share point server for validation. Created the LMA Dashboard report for the management thru Excel and SSRS.
• Good knowledge in using Informatica transformation includes Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored Procedure transformations

Environment: SQL Server 2008 R2/12/14, SSIS, SSRS, Oracle 11g, T-SQL, Toad, DBVisualiser, Informatica

Confidential, Addison, TX.

Responsibilities :

• Involved in the requirement analysis, creation of High level and low level documents
• Used ETL techniques for extraction, cleaning, transforming and loading data into target
• Extensively worked on Views, Stored Procedures and Defined DDL’s for loading data to the staging.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and have written functions, stored procedures and triggers.
• Good Experience in writing scripts using C# in script task transformation for file validation
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task etc.
• Tested Complex ETL Procedures based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import and Export wizard, Bulk Insert.
• Developed drill-through and drill-down reports using SSRS. Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Environment: SQL Server 2008 R2/2012, SSIS, SSRS, Oracle 11g, T-SQL, PL/SQL, Toad

Confidential, Jacksonville, FL.

FS2 Fund Setup

Responsibilities:

• Understanding the business requirements and have created high level and low level design documents.
• Good experience in designing the SSIS packages for data flow, Involved in Database Testing & QA activities.
• Tested Complex ETL procedures based on business user requirements and business rules to load data from source flat files.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Validated the data in the reports by writing simple to complex SQL queries in Stored procedures
• Prepared test data by modifying the sample data in the source systems, to cover the requirements and test scenarios.
• Reviewed the ETL Flow to ensure the transformation rules are applied correctly.
• Created test plans, test scripts, test cases and performed various testing unit testing(UT), System integration testing (SIT)
• Created and executed SQL queries to perform database testing

Environment: Toad, SQL Server 2008 R2, SSIS, SSRS, DB2-Mainframes, TSQL

Confidential

FS2 Tracking

Responsibilities:

• Created the high and low level design documents from the business specification documents
• Involved in the development, testing and deployment of the components, QA activities
• Involved in the extraction, cleaning, transforming and loading data into target.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency
• Tested Complex ETL procedures based on business user requirements and business rules to load data from different sources including Mainframe Db2, flat files.
• Extensively worked on Views, Stored Procedures and triggers.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task etc.
• Created many Stored procedures for data validation for different applications

Environment: SQL, Toad, SQL Server 2008 R2, SSIS, SSRS, DB2-Mainframes

Confidential

ETS & Corporate State Reporting

Responsibilities:

• Handling Change requests - Understanding the business requirements and preparing the Low level design documents, Testing & QA activities.
• Created the low level design documents from the High Level Design documents before development/testing
• Developed many batch programs in COBOL- IMSDB to get the data from IMSDB hierarchy database
• Have created many online CICS applications for different functionalities using Db2 as backend database
• Have written many Cobol DB2 Stored procedures for different application and for data validation
• Extensively used Xpeditor for debugging the Cobol programs and used endeavor to maintain the code version.
• Update and verify JCL’s, PROCS for all the releases and created in different environment for testing
• Prepare the Test Plan, Test Scripts and Test Cases for all the releases and the tested the components, the following are performed- Unit testing, Integration testing, database testing, Boundary testing
• Used Quality Center for tracking all the defects captured and action plans on the defects.

Environment: IBM OS/390, Z/OS, COBOL, CICS, JCL, DB2, REXX, IMSDB/DC, ENDEVOR, QMF, SPUFI, QC 9.2