SUMMARY:

• 13+ years of Experience in Information Technology with skills in Analysis, Architect, Design, Development, Production Support, Testing and Implementation of Netezza, Unix/Linux, Mainframe, SAS and Windows applications
• Leads the development of new warehouse solutions and enhancements
• Experience in ETL design and dimensional modeling
• Hands - on experience working with large multi-terabyte DWH environment Netezza
• Currently a Senior Technical Architect (through Confidential ) at Confidential Health
• Self-motivated, responsible and resourceful professional, having a strong technical background, and committed to stretch challenges and results.
• In Depth understanding of all the phases of Software Development Life Cycle (SDLC).
• Proficient in different phase of testing like GUI testing, Unit testing, Regression testing, Integration testing, System testing and User Acceptance testing.
• Experience in Unix/Linux scripting, SAS, SQL queries, Stored procedures, ESP Cybermation

TECHNICAL SKILLS:

Languages: SQL, SAS, COBOL, .Net, Java, C

Databases: Netezza, DB2, VSAM, SQL Server, Oracle

Tools: Aginity Workbench, Netezza Admin tool, ESP Cybermation Scheduler, TOAD, CICS, Endevor, Xpeditor, ChangeMan, Excel, MS Project, Visio, PVCS

OS: Mainframes(MVS/ESA/OS 390), UNIX/Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

Senior Technical Architect

Responsibilities:

• Responsible to update the Store Universe process to use weekly data instead of Monthly store monitoring data.
• Responsible to lead and implement the enhancements to Imputation methodology, CPM and Nielsen Total Market and Total Store offerings.
• Excellent knowledge on Confidential Health data
• Works closely with business analysts, project managers, data architects, database administrators, and business intelligence developers to design and develop effective data warehousing application
• Leads off-shore teams for the development activities and to implement solutions.
• Evaluate solutions and technologies, and create the suitable architecture
• Create data model and technical design document. Optimize data model for BI tool Microstrategy.
• Estimate the effort and determine the onsite and offshore team requirements. Conduct code reviews
• Follow Production turnover process to move the code to production. Perform production support activities during support window. Help the support team resolve problems.

Technology in the project: Unix, Linux, Oracle, Netezza, Abinitio, OS/390, Mainframes, SAS, ESP Cybermation, PVCS, Endevor

Confidential

Project Leader

Responsibilities:

• Determine the list of business rules and requirements using which the vendor(peoplecube) can be selected for the workspace management
• Work with all stakeholders of the project including vendor(peoplecube) and define the requirement(business, functional and technical requirements)
• Prepare Project Estimates (Size, Effort and Schedule)
• Create Technical design
• Coding, and Testing
• Review other programmers code
• Production Implementation

Technology in the project: IIS 7.0, .Net 3.5, SQL server 2008, peoplecube, PC SAS, SharePoint

Confidential, Greenville, SC

Project Leader

Responsibilities:

• Ensure business requirements are gathered; and scope is well defined
• Has acquired good knowledge on Insurance domain, especially on Eligibility area
• Prepare Project Estimates (Size, Effort and Schedule)
• Create technical design
• Review other programmers code
• Production Implementation
• Use SAS Datastep, PROC SORT, SUMMARY, FREQ, SQL, TRANSPOSE, PRINT and FORMAT
• Create output files in RTFand HTML formats using SAS ODS facility
• Use Excel Pivot table and VBA Macros to create adhoc reports
• Present the results of the analysis with PowerPoint Slides
• Follow CMM throughout the project life cycle
• Provide status report and monthly dash board report for different levels of stake holders including business team.
• Keep knowledge management documents up to date

Technology in the project: Mainframes, Unix, SAS, Oracle, COBOL, JCL, VSAM, CICS, ChangeMan, Xpeditor, MQ

Confidential, Plymouth Meeting, PA

Senior Consultant

Responsibilities:

• Requirement Analysis
• Prepare Project Estimates (Size, Effort and Schedule)
• Design Data Investigation tools(Coverage Tool, Projection Source Code report and Trx report)
• Create Technical Design
• Coding, and Testing
• Review other programmers code
• Production Implementation
• Data investigation for the client inquiries to analyze the difference between Confidential V1, V2 and Legacy systems(XPonent, NPA)
• Create Adhoc reports using SAS and Mainframe, Unix jobs
• Investigate trend breaks in different versions of Confidential reports; viz; V1, V2 and Legacy systems using SAS
• Follow CMM throughout the project life cycle
• Provide status report and monthly dash board report for different levels of stake holders including business team and vendors.
• Keep knowledge management documents up to date

Technology in the project: Unix, Oracle, OS/390, COBOL II, JCL, PC SAS, Mainframe SAS, Unix SAS, TSO/ISPF, VB, MS ACCESS, Cybermation, Excel

Confidential

Senior Consultant

Responsibilities:

• Requirement Analysis
• Follow CMM throughout the project life cycle
• Prepare Project Estimates (Size, Effort and Schedule)
• Technical Design, Coding, Testing and Reviewing
• Create Adhoc reports using SAS for analysis
• Implementation and Production support

Technology in the project: OS/390, COBOL II, JCL, IDMS, Oracle, Unix, PC SAS, Mainframe SAS, Unix SAS, TSO/ISPF, CA-7, VB, MS ACCESS, Cybermation

Confidential

Senior Programmer

Responsibilities:

• Requirement Analysis
• Prepare System Internal Specification and Program specification for the requirement
• Coding, Testing and Reviewing
• Follow CMM throughout the project life cycle
• Prepare Project Estimates (Size, Effort and Schedule)
• Involve in Turnover process using Change Doc. Create Packages and move the elements to SIT/UAT/QAP/PROD. Conduct Verification tests in all these regions.
• Been to onsite for two months for the project implementation of Phase1.

Technology in the project: OS/390, SAS, COBOL II, JCL, DB2, FILEAID, XPEDITOR, CICS, TSO/ISPF, Code Coverage, MQSeries, DQMN, MQCandle