PROFESSIONAL SUMMARY:

• Technology Lead with 10 years of solid SQL server, ETL, Mainframe experience. Has expertise in leading all SDLC stages of application development and maintenance efforts, requirement gathering, design, architecture, development, testing support, Maintenance and Support.
• Expertise in Confidential Application and wholesale banking worked on development and enhancement of customer specific changes and BAU changes. Strong Domain knowledge and internal knowledge on the Application.
• Worked on ETL development initiatives includes SQL SERVER management studio, SSIS, Data Transformation services(DTS), Visual Studio
• Worked on mainframe technologies COBOL, DB2, JCL, CICS, MVS, TSO, ISPF, SORT, VSAM, Cobol Report writer, Endeavor, Change man, File Aid, SPUFI, QMF, EASYTRIEVES, and REXX.
• Strong banking industry knowledge. ­­
• Performed the role of Onsite Lead for projects for Software development.
• Excellent interpersonal and communication skills with Client, IT Managers, Business and Technical Users
• Expertise in using SDLC process for projects that include analysis, design, development, testing, Implementation, Production support of SQL server and mainframe applications.
• Excellent interpersonal communication skills with Client, IT Managers, Business and Technical Users

TECHNICAL SKILLS:

Programming Languages: Confidential - SQL, SSIS package development, VB scripting, COBOL, JCL,CICS, EASYTRIEVE, REXX,HTML,C#, Object Oriented programming

Database/File System: Microsoft - SQL Server 2008/2005/2000 , IBM DB2,VSAM

Confidential ools: MS SQL SSIS, Data transformation services(DTS),SQL server Business intelligence Development Studio, Visual studio 2010, CHANGEMAN,EXPEDITOR,FILEAID,SAR,CA7,SPUFI,ISPF ENDEVOR,NDM

Operating System: Windows 2003/Windows XP/Windows 7,10/IBM OS-390

Version Control Tools: VSS and TFS

PROFESSIONAL WORK EXPERIENCE:

Confidential

Responsibilities:

• The application has high visibility across enterprise due to its high customer base and impact.
• Have created and installed mainframe and distributed components for new initiatives and provided fix for existing Code.
• Have used Change man and Endeavor for migration of the Code and for change control.
• Worked on CA7 for scheduling the jobs and SAR for job monitoring.
• Extensively worked on FILEAID, VSAM, DB2, SPUFI and NDM Tool.
• Have used Remedy to create incident tickets for issues to fix in a timely manner.

Confidential

Responsibilities:

• Worked on ETL data migration initiatives which involves migration of data from several sourcing application including Teradata, Db2, Oracle to SQL Server involving SQL server, SSIS and DTSX process. Have performed transformations from Db2, Teradata, and Oracle sourcing applications.
• Created databases and schema objects including tables, indexes and applied constraints for various applications to the database and written functions, stored procedures and triggers.
• Created SSIS packages using Derived columns, Fuzzy lookup, condition split, Aggregate, Execute SQL task, Data flow Task and Execute package Task. To generate data for reports and to export data from Excel spreadsheets, Text file and Confidential file
• Interact effectively with business analysts, business/application end-users, external vendors, customers, coordinate and provide resolution to all stakeholders with reduced cost and effort.

Confidential

Responsibilities:

• Created stored procedures functions, Tables, views, SQL joins and other Confidential -SQL code to implement business rules.
• Created and implemented the jobs to create and update the data on daily, weekly and monthly basis.
• Performed Data Analysis to extract the Data and separate the entity for the required reports.
• Created SSIS packages to extract data from multi formatted flat files, Excel files, Developed, deployed and monitored SSIS packages.
• Created SSIS package to extract using SSIS designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Term Extraction, Execute SQL task, Data flow Task, Execute Package Task etc
• Research and Analysis for identifying the changes and fixing issues required in the systems.
• Created the High level design and detailed design for the project. Used the standard structured design methodologies and CMM level 5 software quality processes to design and implement systems.
• Worked on gathering requirements from Domain SME’s and analyzed the requirements.
• Participated in client discussion to understand the problem faced by the customers and articulated the same to internal stake holders.
• Prepared Business requirement Document(BRD) and then converted Business requirements into functional requirement specification
• Created UML diagrams including Use case Diagram, Activity Diagram and User interface Cases (UID) as needed.
• Schedule Daily meeting with developers, system analysts and testers to discuss steps and address issues.
• Reviewed test plans and test cases and work with testing team to implement.
• Coordinated User training and drafted System appreciation Document
• Designed and conducted User acceptance testing(UAT) and resolved new scenario bought by users
• Captured the end to end process flows on the application.
• Articulated the Business Value of an Automation Request and documented it for the Project.
• Responsible for creating various projects reports for stakeholder, development and QA teams on Scheduled basis using MS SharePoint.
• Extensively developed programs using COBOL, JCL, DB2 and VSAM, Confidential -SQL, SSIS.
• Performed various levels of testing - Unit testing, System testing and Integration testing.
• Provided support to the entire PEP+ application and change releases.