SUMMARY:

• Over 20 years’ experience in enterprise integration and solution architecture, 15 years of extensive experience as a Data analytical platform professional including 13 years with InfoSphere Information Server, 2 years with AbInitio Product suite, 3 years MicroStrategy and 3 years with Big data (Hadoop) platform In - house/AWS Cloud as well as 5 years with Unix admin and web development.
• Experience includes Bid data platform (HDP Hadoop) admin as well as Data Integration Platform Admin/Architect, an Integration Architecture, ETL CoE (Center Of Excellence), Cloud services (public/private), PaaS, SaaS, Application Architect, UNIX Administration and Java technologies.
• 2 Experience in AWS Cloud services including MCD Eco system integration, Data and environment migration as well as no of POC.
• 13 years’ experience with IBM InfoSphere Information Server products (DS/QA/IA) as an Architect/Admin, DataStage SME, DataStage architect, performance enhancement, developer, environment support, patch management, vendor management and onsite/offshore team management.
• 3 year experience with Analytics platform (MicroStrategy 9.3.4), Big data platform (HDP Hadoop 2.x), and Data Integration platform (AbInitio 3.x product suite) services including environment architect, installation, configuration, and environment administration on public (Amazon AWS) and private cloud.
• Extensive experience in UNIX administration, scripting using AWK and SED, database programming using SQL, PL/SQL and standard built-in package in RDBMS like Oracle, Informix, SQL*Server, Columnar databases like Teradata and RedShift as well as NoSQL databased like Hive and HBase, application development and web development.
• Expertise in Enterprise Data Integration platform like IBM InfoSphere Server 11.5/11.3/8.7/ 8.0.1 and AbInitio 3.0.2 in cloud.
• Experience in Big data environment (Hortonworks Hadoop 2.1.5 product suite) services of Installation / Configuration / Administration / Security / Patch / Vendor / Environment management at bare metal on Client site as well as Amazon EC2 cloud.
• Implemented AWS Cloud solution into Data Analytical Platform by provided integration services between AWS and DataStage/Hadoop environment, Migrated In-house Hadoop environment to AWS as well as transferred 40 TB data to AWS using Snowball appliance and creating awareness/integration of­ new AWS services to MCD Data Analytical platform.
• Proficiency in Analytics platform like MicroStrategy 9.3.4 and R language setup (Installation/Configuration/Patching/Trouble shooting) as well as Self-service Analytical tool like Tableau.
• Provide enterprise wide solution and recommendation on technology/product/environment.
• Participate in strategic decision by doing POC and finding new features/capabilities to in corporate company strategic vision.
• Serve as a lead troubleshooter to diagnose product / environment issues, identify reuse opportunities and create docs, environment / project setup jumpstart docs, created no of utilities and health check scripts.
• Extensive experience and knowledge in Star Schema, Snow Flake, Fact Constellation, Data Mining and Data Modeling.
• Strong leader in gathering user requirement, Source to Target data Mapping, Slowly Changing Mapping Creation, Star Schema Mapping Creation, Auditing, ETL application designing, development, testing and roll-out of data mark and DW.

EXPERTISE AREA:

• Big data and analytical platform admin/architect
• ETL Center of Excellence
• IBM Information Server (DataStage) SME
• Application Architect
• Creative problem solver
• Vendor Management
• UNIX Administration
• Data Integration platform admin/architect
• Cloud Integration/Solution architect
• Communication skill
• Translate Strategy to Action
• Team leadership
• Strategic thinking and planning
• Demand/capacity management

TECHNICAL SKILLS:

Big Data Technologies/Cloud platform: HDP - Hadoop (2.1.5) installation with misc. products like Snappy, Pig, Hive, Hbase, Tez, Hcatalog, Ozzie, Sqoop, Mahout. Flume and Solr on Linux, Amazon AWS S3, RedShift, Snowball 1.0.1.47

Data Integration /Information Management tools: IBM InfoSphere 11.5/11.3.1/8.7 /8.0.1.2 product suite, AbInitio 3.0.2 Product suite and Oracle Golden Gate

Analytical tools: MicroStrategy 9.3 (HF4), Tableau 9.0, SAS and R Packages

Business Intelligence/Data Warehousing: Enterprise Data Warehouse (EDW), ODS, Click Stream Data Warehouse, Star Schema, Snowflake Schema, Fact Constellation, 3/2 Tier architecture, Data Mining and Data Modeling

Operating System: SuSe/RedHat Linux, AIX 6/5/4.x, Sun Solaris 10/9/8/7, HP-UX 11.11, SCO UNIX 5/3.2AS/400, Windows, AS/400, OS/390, VMS and Mainframe

Languages & scripting: Korn/Bourne Shell, AWK, SED, Perl, SQL & PL/SQL, R and Java

Databases (RDBMA, NoSQL, Columnar): RedShift, Teradata, Oracle 11/10/9i/8i/7.x, Informix, DB2, MS-SQL Server 7.0, MS-Access and SQL Server, Hive, HBase, Netezza and Exadata

Web Technologies: HTML, DHTML, Java Script, JSP, Servlets, Java Bean and EJB.

Other: PeopleSoft EPM 8.9, Change Management CCC/Harvest, Alphablox, SQL*Loader, SQL Server, Crystal Reports, Control-M scheduler, UC4 and Autosys, ESP, SightLine, JIRA, Microsoft SharePoint and MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Manager, Solution architect

Responsibilities:

• Acting as a Data analytical Platform Solution/Integration architect (general practitioner) in planning, designing, implementing and administering analytical platform with managing broad range of multi-vendor, client/server and network computing solutions.
• Responsible for strategic product/process/service planning, design, implementation, administration, and operation of disparate analytical platforms to ensure maximum availability and reliability of analytical solution components.
• Serving as a SME of IBM Information Server 11.5/11.3.1.1 , co-owner of MicroStrategy 9.3.4 from Infrastructure and Product management standpoint as well as responsible from Hadoop environment/services setup and enhancement.
• Innovation and continuation of services like Big data technologies (Installation and upgrade of HDP - Hadoop 2.1.5 eco system (Snappy, Pig, Hive, Hbase, Tez, Hcatalog, Ozzie, Sqoop, Mahout. Flume and Solr on SUSE Linux)), POC of integration of ETL tools with RedShift on Amazon Cloud, installation of misc. products like R on private and public cloud.
• Provided the latest technologies installation/configuration/POC services to empower Customer analytics insights with:
• Big Data technologies Hadoop 2.1.5, Presto, DataSift, Wolfram, Datameer, Splunk-hunk
• Data Integration tools like IBM Information Server 11.5/11.3.1 and Talend
• Reporting and Analytics tools like MicroStrategy 9.3.4 with R Package
• AWS Snowball platform setup and data migration up to 15 TB to AWS S3 and from S3 to RedShift.
• Self-service BI too like Tableau v9.
• Data modeling tool like CA Erwin Data modeler 9.5
• Actively participated enterprise Data center migration project covering Corporate IT Data solution infrastructure.
• Communicated effectively and candidly with proven ability to lead in a geographically dispersed, multi-vendor, cross-functional team environment on a daily basis
• Continuously developed improvement plan and created/implemented no of processes for existing Data analytics platform to increase reliability and optimize cost.
• Coordinate the activities of external Data management/analytical product suppliers and internal resources (7x24x365) Key business partners include all internal users of Data analytics systems, GDW leadership, and Confidential 's IT Foundation organization.
• By looking at customer’s interest, I have created no of reusable documents by leading change/innovation and build team as well as leverage talent.
• Completed no of strategic projects with influencing team members as well as through team work

Environment: HDP-Hadoop 2.1.5, AWS Cloud services, IBM Information Server 11.5/11.3.1/8.7 , MicroStrategy 9.3.4, Tableau 9, R Packages, CA Erwin Data Modeler, SUSE/RedHat Linux, AIX 5.3/6.1, Sun Solaris 9/10, Teradata, SQL*Server and Oracle.

Confidential

Integration Architect

Responsibilities:

• Act as a subject matter expert (InfoSphere product suite) in designing, supporting, issue resolution, performance tuning, system debugging, best practice consulting, job architecture, ETL process architecture for users and involving the use of Integration architecture product and services.
• Installation, and configuration of IBM Information server 8.0.1.2 (DataStage, Quality Stage, Information Analyzer and Metadata workbench), AbInitio 3.0.2 (co>op, EME, key server, Data Profiler) product suite, DB2Connect and different ODBC drivers etc.
• Administrate, maintain, monitor, support and analyze Confidential ' DataStage/AbInitio ETL infrastructure.
• Worked as Integration/ETL environment architect, responsible for new environment requirement analysis, project plan, environment creation, software, PMR, service request, key request and patch management into all ETL environments.
• Provide support/solution to development teams on issue resolution (performance tuning, system debugging, best practice, consulting, job architecture, ETL architecture etc. as an InfoSphere (DataStage/Information analyzer) subject matter expert (SME).
• Coordinated with development teams, systems administrators, network administrators, database administrations and third party consultants to ensure service availability.
• Design and develop system standards, environment usage guideline, methodologies, best practice and SOP for ETL environment.
• Created no of health check processes and collected environment related information for strategic planning purpose.
• Developed no of processes and document for level 1 & 2 support team as well as user community to resolve issue by themselves.
• Provide architecture guidance and solution to users on no of different areas including environment, product, customized DataStage applications, concept, techniques, ETL process, performance tuning, systems debugging and DataStage development best practices.

Environment: IBM Information Server 8.0.1.2 and AbInitio 3.0.2 Product suite, AIX 5.3/6.1, Sun Solaris 9/10, GoldenGate, Oracle 9/10/11 and Teradata.

Confidential

IT Consultant

Responsibilities:

• Participated into IBM Information Server Installation (DataStage 8.0) process and setup.
• Contribute to the project planning process by tasks, deliverables and estimated hours.
• Created functional and technical specification, mapping document, process flow diagram, flow chart and test cases of existing long running server jobs.
• Provided conceptual design of long running processes into parallel environment and represents design to team lead and ensure the design will comply with the enterprise technical architecture.
• Developed applications based on functional/technical specification documents and involved in designing, coding and testing of program modules.
• Converted long running server jobs and complex SQL into parallel jobs.
• Assisted in developing and updating standards/best practices in ETL design, performance management and maintenance.
• Created test plan, regression testing, and impact analysis of changes into environment.
• Provided recommendations for data cleansing standard and process.
• Provided mentoring and guidance to team members on job design, development and errors.
• Provided design reviews and code walk-through
• Create, execute and document tests necessary to ensure that an application or technical environment meets performance requirements.

Environment: Enterprise Data Warehouse, IBM Information server V8.0, DataStage 8.0 Enterprise edition, Sun Solaris 9/10, Oracle 10g, Window XP, SQL, PL/SQL and UC4.

Confidential

DataStage Tech Architect/Lead

Responsibilities:

• Lead the design of and review the technical competencies of work deliverables to functional lead and offshore team.
• Hands on technical lead responsible for interacting with different source system tech. staff, infrastructure team and DBA to create efficient and seamless technical environment.
• Tuned DataStage jobs and worked with Source team, Functional team and Database team to improve performance.
• Extract data from different source and bring data into PeopleSoft OWS environment.
• Develop DataStage Extract/Transform/Load jobs using STAR Schema and followed development standard into different projects.
• Provide project documentation and knowledge transfer to Production support group.
• Served as a point of communication for various technical standard/ procedures, documented and place under proper change control.
• Walk-through of applications/project designs to other architects validate/review and ensures the application design is in comply with the enterprise technical architecture.
• Assists in developing documentation for business requirements, transformation logic, process descriptions / flow charts, detailed design specification, test plan and implementation plan.
• Engaged in overnight and weekend hours to communicate with Offshore development teams
• Assign task to Offshore ETL developers, provide day-to-day technical direction, and manage assigned work deliverables to defined target dates and assure quality, documented and production ready work deliverables.

Environment: DataStage V7.5 Server edition, PeopleSoft EPM 8.9, Operational Data Warehouse, Window XP, SAP, SQL*Server, Oracle, SQL, PL/SQL, DOS Batch files, Crystal Report 9.x, nVision report and Tivoli.

Confidential

Lead Developer/Project Coordinator

Responsibilities:

• Assists in developing documentation for business requirements, transformation logic, process descriptions / flow charts, detailed design specification, test plan and implementation plan.
• Developed DataStage Extract/Transform/Load jobs using STAR Schema and followed development standard into different projects.
• Developed and Enhanced processes using SQL, PL/SQL, SQL Loader code and Unix Shell scripts, which are extracting data from web logs and load data into Oracle.
• Providing DataStage production support and enhancement of an existing multiple projects.
• Assign task to Offshore ETL developers, Provide day-to-day technical direction, and manage assigned work deliverables to defined target dates and assure quality, documented and production ready work deliverables.
• Lead the design of and review the technical competencies of work deliverables.
• Ensure compliance with coding standards, source code version control, build procedures and deployment procedures.
• Assists in identifying current and future reporting requirements utilizing current successful strategies and developing business use cases.
• Worked overnight and weekend hours to communicate with Offshore development teams
• Identifies business needs, evaluate business and technical alternatives, recommend solutions and participate in their implementation.

Environment: DataStage Enterprise Edition/Server Edition (V7.5/7.1, Parallel Extender), Click Stream Data warehouse, WebHousebuilder, Web Trend Reports, Sun Solaris, DB2, Oracle, SQL, PL/SQL, Shell scripts, SQL*Loader, TNG and Control-M

Confidential

DataStage Consultant

Responsibilities:

• Collaborate with analysts on paper ETL methods and overall data flow architecture.
• Monitor/review other ETL programmer’s deliverables to ensure adherence to uniform application development practices is being followed.
• Develop DataStage Extract/Transform/Load programs using STAR Schema and followed development standard.
• Used DataStage XE/390 for unload from Mainframe, AS400 and DB2.
• Developed Application using Parallel Extender and developed Custom parallel stage.
• Perform complex data and Date conversions using Data Stage Software Development Kit (SDK) transforms
• Developed customized Routines for date conversion and other data problems.
• Replaced COBOL and C programs with DataStage jobs.
• Wrote custom Job Control Routines to take care of restart ability if at all a job fails.
• An automated email messaging was implemented in the Korn shell script and DataStage application to notify any rejected records.
• Developed SQL, SQL Loader code, PL/SQL Programs and Unix scripts.
• Created a flow chart diagram to demonstrate the process to the team.
• Attend design walkthrough sessions and providing recommendations.
• Develop/execute/document detailed test plans.
• Provide program documentation, including restart/recovery procedures

Environment: DataStage XE Suites 7/6/5.2, Enterprise Data Warehouse, Parallel Extender, AS/400, IBM 390 Mainframe, MF COBOL, Alphablox, Crystal Report, DB2, SQL Server, Informix, Oracle, SQL, PL/Sql, Control-M and HP-UX 11.11