SUMMARY

• 11 Years of IT experience in Application Development and Maintenance, Architecture in SAS and Mainframe applications
• 6 Years of IT experience in SAS ETL Architecture, Development, enhancement, maintenance, Production support, Data Mapping, Data Modeling, Reporting including Business requirement, Functional requirement gathering.
• 5 Years of IT experience in Mainframe application Architecture, Development, enhancement, maintenance, Production support including Business requirement, system requirement gathering.
• Knowledge on Databases like SQL Server, Teradata, Oracle, DB2, IMS, IDMS and COBOL with strong SQL coding skills.
• Lead projects from initialization phase from capturing business requirements to final phases of testing.
• Strong communication skills.
• Served as mentor and reviewer to junior specialists in all areas of Data warehousing, ETL and Mainframe.
• Experience in End user training, documentation, and Audit record maintenance and application and product demos.
• Ability to quickly adapt to changing priorities, requests, and environments.
• Dedicated to maintain high quality standards.

TECHNICAL SKILLS

Operating System: UNIX, Linux, Windows, OS/390, Z OS.

Languages: Base SAS, SAS Macros, BTEQ, COBOL, JCL, Easytrieve.

DBMS: Oracle, Teradata, Sql server, DB2, VSAM, IMS - DB, IDMS

SAS products: SAS EG, SAS DI, SAS WRS, SAS IDP, SAS MC, LSF, SAS Admin, SAS ECM, Web service calls

Special software: CICS, ADSO, Changeman, Endeavor, Autosys, SVN Tortoise.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Technical PM Lead for Onsite-Offshore team for SAS ETL developers.
• Create Technical specification documents from Functional requirements and conducting walkthrough meetings with Systems Analysts.
• Coordinate with Project managers to divide the project into smaller modules and helping them in defining the time lines based on the development complexities.
• Build UNIX shell scripts for new SAS programs to be executed from Autosys scheduler andcreating migration documents and coordination with ETL support team in code migration to the higher environments.
• Perform SAS Admin activities using SAS MC in creating Metadata libraries for new source systems and creating new access groups for different stake holders.

Confidential

Responsibilities:

• Technical PM Lead for Onsite-Offshore team for SAS ETL developers, coordination
• Working with Business Project managers to divide the project into smaller modules and helping them in defining the time lines based on the development complexities
• Partnered with business users in identifying, prioritizing & resolving production issues
• Created UNIX shell scripts to execute SAS programs through Autosys scheduler
• Creating the Technical Specification documents and conducting the walk through meetings withSystems Analysts
• Creating the migration documents and migrating the code to the production environment
• Analyzing the dependencies between the jobs and scheduling them accordingly using the Autosys Scheduler, Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

Confidential

Responsibilities:

• As a SAS ETL architect, Lead the End to End design and development of both E-Trade and BRM implementation,
• Worked with business analysts to identify the appropriate data elements for required capabilities, Worked with System Analysts to identify the proper sources for required data elements and to determine the accuracy of the data,
• Assigned the work to development team by creating the individual tasks and updating the status to the project managers
• Designed and developed Batch Control process to run SAS DI jobs in batches for restart ability and recoverability
• Identifying the common functionality between the processes and created reusable code using SAS macros
• Designed and developed the Handshake Interface code between SAS DI and MS CRM, Created the SAS DI jobs and applied transformations using lookup, sorter, remove duplicate, joiner,etc,
• Designed parallel instances of SAS DI Load jobs and did performance tuning to bring download times from 10 hours to 2 hours
• Facilitated the Production move ups of SAS DI components from Acceptance to Production environment
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.

Confidential

Responsibilities:

• Designed the SAS Framework to migrate the AML jobs from Windows based business owned environment to Linux based Enterprise governed environment,
• Liaised with stakeholders from Enterprise SAS/Teradata governance team to ensure code compliance for Migration to Enterprise governed environment
• Working with Business Project managers to divide the project into smaller modules and helping them in defining the time lines based on the development complexities
• Partnered with business users in identifying, prioritizing& resolving production issues Created UNIX shell scripts to execute SAS programs through Autosys scheduler
• Creating the Technical Specification documents and conducting the walk through meetings with Systems Analysts,
• Extracted the data from various sources like Teradata, SQL server, Oracle using
• Creating the migration documents and migrating the code to the production environment, Analyzing the dependencies between the jobs and scheduling them accordingly using the Autosys Scheduler
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

Confidential

Responsibilities:

• Working closely with the business users to understand the requirements and converting them into project level technical capabilities
• Worked with business analysts to identify the appropriate data elements for required capabilities
• Designed and developed the 5 KPI reports using SAS stored procedures and ported the Web reports to SAS Information Delivery portal
• Facilitated the Production move ups of ETL components from Acceptance to Production environment
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.

Confidential

Responsibilities:

• Active participation in preparing AS-IS and TO-BE model diagrams of delivery systems, capturing the Entity-Matrix diagram for the delivery systems impacted, capturing the pain points and needs of the delivery system by interacting with the business folks and helping the team to come with RFI questionnaires for delivery systems.