SUMMARY:

• Business driven and result oriented Technologist, with 13+ years of IT experience spread over Architecture, design, development, testing, implementation and support of enterprise Legacy and ETL Data Warehouse(EDW) Business Intelligence applications comprising of in depth business knowledge in Payment Systems/Fraud/Risk, Retail Banking & Securities, Healthcare Membership/Enrollment and Pharmacy/Prescription based business applications, Strategic Project Management.
• Specializes in data warehousing, Relational Database modelling, ETL methodology and Business Intelligence infrastructure building, data migration, and relational database systems development with Waterfall and Agile SDLC model.
• Experienced in Requirement Analysis, Developing Business Systems Source to Target Mapping, Test Design, Test Case preparation, Test Execution and Management.
• Expertise in developing software products using object oriented technologies - using a variety of modern programming languages like Python, Java etc.
• Experience developing cloud software services and solid understanding of design for scalability, performance and reliability, Application Integration - DevOps.
• Expertise in Data Integration and Data Conversion ETL development projects, building Business processes/graphs/mappings using ETL tools Ab Initio 3.x, Informatica Powercenter 9.x.
• Solid hands on experience in developing PL/SQL, Stored Procedure and Unix Shell scripting.
• Experienced with Batch systems scheduling and processing using Control M, Tivoli, Autosys, Crontab etc.
• Experienced in Business Intelligence Reporting tools such as Micro strategy, Cognos, and Tableau.
• Cloudera Certified Hadoop Developer, Cloudera Certified Hadoop Administrator.
• Sound programming capability using Python, core JAVA along with Hadoop framework utilizing Cloudera Hadoop Ecosystem projects (HDFS, Spark, Sqoop, Hive, HBase, Oozie, Impala, Zookeeper etc.), NoSQL (Mongo DB).
• A successful and experienced Project Management Professional (PMP) - Subject matter expert in change, configuration and release management processes with strong process discipline complemented with extensive experience in software development lifecycle and project management methodologies.
• Extensive experience in managing Global delivery teams - onsite & offshore comprising of ~25 team members.
• Has strong development experience working in Legacy IBM Mainframe z O/S/MVS, COBOL, DB2, CICS, JCL, and Enterprise level job schedulers like Control M, TWS, Autosys and Tivoli.

CORE COMPETENCIES:

• Payment Systems: Point of Sale, Fraud, Risk, Authorization business modules for Confidential .: 8 years, Confidential: 1 year
• Retail Banking : Securities & Loans/Deposits business modules for Citi Bank: 1 year
• Healthcare: Membership, Enrollment, Claim, Adjudication, Prescription Sale, Pharmacy/Clinical, New Member onboarding/communication business modules for Confidential: 5 + years
• Solution Consultant: Expert in Data Warehouse Architecture, Design and Data Modelling.
• IT Project Lifecycle: Requirement Analysis, Design, Testing/QA, Implementation, Support, Costing & Budgeting, Project Scheduling.
• Exposure to both traditional Waterfall model as well as Agile Development Methodology(Rally).
• Core experience in ETL framework: Ab Initito 3.x, Informatica 9.x, Unix Shell Scripting.
• Sound programming capability using Python, Core Java, Java Enterprise Edition(JEE), C, C++
• IBM & Cloudera Certified Big Data Consultant - Extensively working in Cloudera Hadoop Framework utilizing Hadoop, Scoop, Flume, Hive, HBase, Impala, Yarn MR2, Zookeeper, Oozie, NoSQL databases (Mongo DB).
• Data Modelling, Data Architecture, Data Mining, Data Analytics.
• Database exposure to RDBMS/DB2/Oracle: SQL freak.
• Experienced in BI Reporting suite: Micro strategy, Cognos, and Tableau.
• Batch Scheduling using: Control M, TWS, Tivoli, Autosys, Crontab.
• SDLC Release/Change management/tracking using HP Quality Center (QC), JIRA, BMC Remedy, VIPER.
• Exposure to Open System stack: GitHub, Jenkins, Web Services, Restful API, Service Routing, Messaging - RabbitMQ.
• Mainframe, MVS Z O/S, DB2, JCL, VSAM, Infoman, Expeditor, Endeavor, COBOL, FILEAID, DFSORT, CICS, SDSF/IOF, TSO/ISPF, Easytrieve.
• Project Management Professional (PMP): Custom Software Development, Database Design (RDBMS), System Migrations, and Enterprise wide Integrations.
• Value-added leadership: Cross-Functional supervision, Team building & mentoring, Client relations & presentations, Business & IT Planning, Vendor Management.

PROFESSIONAL EXPERIENCE:

Application Integration-DevOps Engineer

Responsibilities:

• Enhancing experience of users from eBay, Amazon & other ecommerce giants checking out with Confidential and improving the guest to member conversion rate.
• Part of Managed Stage Platform team working on next generation Platform which powers Campaigning, Contextual and Offline targeting of Customers.
• Developing and maintaining Confidential ’s core online payment systems’ various critical web services components using Python scripting, Java.
• Full Stack Web development of Monitoring and Analytics for the User Platform Services in Java and Python.
• Debugging & troubleshooting application service performance issues.
• Application Integration - DevOps.
• Agile Project lifecycle implementation using Rally.
• Oracle Database Session monitoring & Performance tuning.
• Analyzing Structured & Unstructured data using Cloud.
• Developing & maintaining Big Data Apps. Wrote Hive QL, Pig Scripts to deep dive into application data & logs to answer analytics questions. 
• Business User Data & service request support.
• Helping Application users to unblock various system & configuration issues in Managed Stage.
• Defect Tracking & Resolution, Coordination, mentoring new hires, managing teams and projects.

Used platforms:

• Programming language: Python, Java
• Scripting: Python, UNIX Shell, SQL
• Database: Oracle, MongoDB, HBASE, PL/SQL
• Cloudera stack: Hive, Pig, Oozie, Pig, hdfs, scala, spark
• No SQL: MongoDB
• Open System Stack: Java, Python, Git, Jenkins, Maven, RabbitMQ, Restful web services, Mesos, Apache Aurora.
• Integration tools: JIRA (Defect Tracking), Rally(Agile)

Confidential, Pleasanton, CA

Cloudera Hadoop Developer/Admin 

Responsibilities:

• Actively involved in designing, developing and implementing a Data Repository to retain last 10 years’ clinical data, comprising of pharmacy point of sale transactions, covering various scenarios like Sale, Void/Unsell, Return, etc. CDR is much valuable for Kaiser to identify various kind of patterns like Fraud (prescription drug being stolen in pharmacy), trends in returns, max wait time in a particular pharmacy etc., which altogether helps business to improve the patient care/service at Pharmacy and prevent proactively events of fraud etc.
• Executing adhoc queries for trend analysis and finding various transaction patterns.
• Building Hadoop clusters/loading to retain 10 years back pharmacy transactions making it readily available for any kind of data analysis, replacing slowly dependency on limited period data retention on traditional EDW.
• Identifying other related source of data to build a comprehensive and robust data repository with the intention to make it a single marketplace for future generation fast paced Pharmacy Analytics platform.
• Imported data using Sqoop to load data from relational database/ RDMS/Oracle tables to HDFS on a regular basis.
• Created Hive tables, loaded data and wrote Hive QL queries to further analyze the data.
• Created Hive queries that helped Pharmacy prescription sales analysis spot emerging trend/patterns by comparing fresh data with EDW reference tables and historical metrics.
• Involved in loading data from UNIX/Linux file system to HDFS.
• Designed and developed automated, complex and efficient ETL processes to match multiple large-scale dataset together.
• Developed Map Reduce Programs for data analysis and data cleaning.
• Migration of ETL processes from MySQL to Hive to test the easy data manipulation.
• Developed workflow in Oozie to automate the tasks of loading the data into HDFS and pre-processing, Pig jobs and Hive jobs.
• Worked on Hive for further analysis and for generating/transforming files from various analytical formats to text files.
• Managed and reviewed Hadoop log files.

Used platforms: Cloudera Apache Hadoop Ecosystem - Cloudera Hadoop Framework, Hive, HDFS, Impala, Sqoop, Spark, UNIX AIX, Oracle 11g, Flat Files, and IBM AIX, Python.

Data Warehouse Project Lead & Lead Data Analyst

• Providing single trusted data source (Integrated pharmacy data)
• Providing aggregated as well as prescription level data
• Creating flexibility to incorporate future data sources
• Provisioning the data marts and data feeds to meet the needs of pharmacy
• Designed the application solution framework, developed and implementation of extraction, transformation and load process (ETL), OLTP reporting for the Pharmacy Data Warehouse from heterogeneous source systems using Informatica 9.5.x.
• Major projects worked are: EED Cutover, Bridgefeed Cutover, EPS General Ledger (GL), POS Transaction Data Store (TDS), Gateway, Performance tuning of EPS, GL Decoupling.
• Developed slowly changing dimension mappings of type1, type2 using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, ranker, Joiner, Stored procedure and Update Strategy.
• Used PL/SQL to embed complex business logic in stored procedures.
• Built Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Implemented partition based staging load utilizing pre-SQL and post-SQL in session configurations.
• Created UNIX shell scripts for file integration and Model scripts.
• Extensively worked on Code Migration from Development, QA, Systest, UAT, and Production.
• Actively involved in tuning performance for existing and new source queries - in Informatica and database level.
• Worked closely with Business owner/regions, SME to capture Business requirements and translate into Technical Specifications/Functional Requirement Document (FRD)/Logical Solution Design Document (LSDD).
• Performed Source System Analysis (SSA) to identify required source data for new business requirements to move data elements to target tables.
• Involved in effort estimation, risk identification and project planning/scheduling.
• Involved in Data Modeling, Design and Development of Informatica objects.
• Prepared Test Plan, Test Case, and Test Scripts for Unit testing, System Integration testing (SIT), and User Acceptance testing (UAT).
• Performed Impact Analysis based on the Change request.
• Effort Estimations for Change Requests/new enhancements of ETL mappings.
• Change Management, working on Production Code Deployment process involving CRQ, Work Order, tasks in BMC Remedy tool.
• PDW applications generate various downstream feeds for regions which help them to perform various pharmacy/clinical data research & General Ledger is extremely important for Kaiser Finance team for auditing the Prescription Sales Revenue from Pharmacies across all regions.

Used platforms: Informatica Power Center 9.5.x, Oracle 11g/10g, IBM Mainframe, SQL, UNIX Korn Shell, HP Quality Center 11.52, Rally (Agile Methodology), IBM TWS Scheduler, Flat Files, and IBM AIX, Remedy.

Data Warehouse Project Lead & Data Analyst

• Developed and implemented ETL solutions for LIS Acumen Business Validation Automation process and further in LACARE business rules using ETL tool Informatica Power Center 9.5.x/ Ab Initio.
• Created several Informatica Mappings for the CDC change data capture to populate data into Dimensions and Fact tables.
• Involved in Performance optimization in Informatica and database level.
• Used SQL, PL/SQL to embed complex business logic in stored procedures and functions.
• Created UNIX shell and Perl scripts for file integration.
• Effort Estimations for Change Requests/new enhancements of ETL mappings.
• Carrying out the Code Reviews and Production deployments process using Confidential Standards.
• Defined scope and business rules of project, gathering Business Requirement and documenting those using models and further translated into Functional Requirement Document (FRD)/Logical Solution Design Document (LSDD).
• Created data flow diagrams, data mapping from Source to stage to target mapping documents indicating the source tables, columns, business rules/filters/transformations to be applied.
• Wrote Complex SQL scripts to perform Data validation and Data integrity testing.
• Prepared Test Plan, Test Case, and Test Scripts for Unit testing, System Integration testing (SIT), and User Acceptance testing (UAT).
• Involved in effort estimation, risk identification and project planning/scheduling.

Used platforms: Informatica Power Center 9.5.x, Ab Initio, Windows-7, Oracle 10g/9i, IBM Mainframe, SQL, IBM DB2, Korn Shell, IBM TWS Scheduler, MS-Office Tools, Flat Files, and IBM AIX, Remedy.

ETL Development Lead

• Having excellent customer and business interface, involved in Customer business requirement gathering meetings and automated business validation audits to enhance the customer feed experience.
• Developed and implemented ETL solutions for building Part D Enrolment/ Disenrollment Business reporting process and further in the Exclusion of LACARE Dual Demo Members, using ETL tool Ab Initio.
• Graph Analysis and Code Changes for changing business needs using Ab Initio, Oracle and UNIX.
• Extensively used PL/SQL to embed complex business logic in stored procedures.
• Involved in performance tuning from Oracle and job automation.
• Implemented parallel process on the existing system and reduced significant percentage of Weekly and Monthly run time.
• Performance tuning of existing ETL process.

Technical platforms: Ab Initio GDE, DB2, SQL Server, and UNIX AIX, Shell scripting, Mainframe, IBM TWS Scheduler, and BMC Remedy.

ETL Development Lead

• Requirements gathering and discussions with Clients and Business Analyst to understand the Business Logic.
• Involved in effort estimation and project planning.
• Involved in Data Modeling, design and Development of complex graphs.
• Developed and implemented ETL solutions for building Medicare Letter Optimization (MLO) Process using ETL tool Ab Initio.
• Having excellent customer and business interface, involved in Customer business requirement gathering meetings and automated business validation audits to enhance the customer feed experience.
• Prepared Unit Test Case document and perform Unit testing.
• Effort Estimations for Change Requests/ new enhancements of ETL processes.
• Performance tuning of existing ETL process.
• Carried out the Code Reviews and Production deployments process using KP Standards.

Technical platforms: Ab Initio GDE, DB2, SQL Server, and UNIX AIX, Shell scripting, Mainframe, IBM TWS Scheduler, and Remedy.

ETL Designer & Lead Business Analyst

• Lead, designed and implemented key business rules for GIW-GLA (Global Liability Analytics) application using ETL/Ab Initio.
• Worked as a Technical Architect to design/build SFS Data mart from scratch, which comprises of various security lending and other security assets managed by Citi.
• Being the Offshore lead, handled 15-member team and delivered the project amidst of tough deadlines and changing requirements.
• Prepared case study on Performance Tuning Concepts.
• Built the data warehousing components and provided support for User Acceptance Testing and deployment of application.
• Performance Tuning in ETL and in Database level.
• In this project, I was involved in requirement gathering, data modelling, creating business rules mapping, interacting with Microstrategy reporting teams to implement/build the best possible Datamart consisting a number of Fact, Dimension and Summary tables based on customer business needs.
• Worked closely with Business owner/regions, SME to capture Business requirements and translate into Technical Specifications/Functional Requirement Document (FRD)/Logical Solution Design Document (LSDD).
• Performed Source System Analysis (SSA) to identify required source data for new business requirements to move data elements to target tables.
• Involved in effort estimation, risk identification and project planning/scheduling.
• Involved in Data Modeling, Design and Development of ETL processes.

Technical platforms: Ab Initio GDE, Oracle/SQL Server, and UNIX AIX, Shell scripting, Mainframe, IBM TWS Scheduler, and Microstrategy.

Lead ETL & Microstrategy Reporting Developer

• Enhanced key ETL/business modules for Visanet Incentive Network data mart and later worked in building key business intelligence reports for Visanet Incentive Network (VIN) loyalty campaigns for merchants and member banks.
• Created and managed lifecycle of APRIMO Sweepstakes and Campaigns.
• Took initiative in fine-tuning performance for long running Microstrategy Reporting Queries.
• Single handedly completed the project amidst of tough deadlines and unforeseen issues.
• Performed Impact Analysis based on the Change request.