SUMMARY

• 7 plus years of IT industry experience encompassing a wide range of skill set, roles and industry verticals
• Extensive experience with analysis, design, development, customization and implementation of processes on IBM DATASTAGE, IBM QualityStage, Unix Shell Scripting, db2, Oracle, SAS (Basics), Perl (Basics), IBM Infor­mation Analyzer, Control M, Autosys
• Domain knowledge in Credit Card, Financial Domain in Banking, and Health Care
• Proficient in analyzing and translating business requirements to technical requirements and architecture
• Strong database skills, Shell Scripting and development knowledge
• Experience in leading and managing teams internally. Worked as an Application Developer and a Lead with projects running flawlessly
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player
• Proficient in Data warehousing concepts like Star Schema, Snowflake Schema, Enterprise Data Warehouse, Data Marts, Operational Data Source, Dimensions, fact tables
• Data Warehouse activities for maintenance and operations
• Extracted and transferred source data from different database like Oracle, SQL SREVER, DB2 and flat file into ORACLE, DB2
• Developing mappings and parallel jobs in DataStage to load the data from various sources into the Data Ware­house different stages in Data stage like Aggregator, Join, Filter, Copy, Change Capture, Funnel, Lookup, Merge, Pivot, Remove Duplicates, Sort, Surrogate key Generator, XML Stages, Sequences, Quality Stages, Debug Stages, Web Service Stages, External Input/Output Stages, Sequential files, Complex Flax Files, Transformer and custom stages like Build Op’s
• Performance tuning for all the jobs and project level scripts for automation and maintenance
• Worked with Erwin Data Modeller tool for creating models that were identified using solution sessions from IBM In­formation Analyzer
• SPOC for IBM InfoSphere Server setup, installation and admin related activities
• SME for IBM InfoSphere Datastage jobs that involved complexity which had various sources like Excel, Oracle ODS for worksheet generation which involves costs calculations and settlements

TECHNICAL SKILLS

Technologies: IBM DataStage(ETL), Shell Scripting (UNIX), Oracle v9.1/10g/11 i/12c, IBM DB2

Tools: IBM DataStage Designer, IBM DataStage Director, IBM DataStage Administrator, IBM Information Analyz­er, IBM DB2, Control M, Oracle PL/SQL Developer, Autosys, IBM QualityStage, Mercury Quality Center, MyService Now, HP ALM, Perl (Basics), SAS (Basics), R (Basics)

PROFESSIONAL EXPERIENCE

Senior System Engineer

Confidential, Lansing, MI

Responsibilities:

• As a Senior Software Engineer, I was involved in various assignments under Healthcare domain that include working for State of Michigan's Medicaid program and New Hampshire Vital Stats project. Various projects within the State of Michigan include Children Special Health Care Services (CSHCS), Unique Health Plan ID (UHPID), Managed Continuum of Care (MCC), Facility Settlement (FS), Provider Enrollment (PE).
• For New Hampshire, worked on Marriage, Birth, Death Statistics and loaded them into Data Warehouse. Analyzed data to suggest State of New Hampshire on various cases.
• CSHCS is a program under medicaid that treat beneficiaries with low or no cost. There are various modules within this project; Enrollment, Payment, Insurance, Correspondence, and Document Conversion.
• UHPID is an initiative project is to combine various Providers with a Unique ID based on the Contract of the program. By this, Provider will have a unique method of communication to deal with future payments, methods of care, level of care and many more.
• Level of Care (LOC) is to ensure that the medicaid services are provided continuously no matter what and how the care is provided. This will also include beneficiaries that are not enrolled when the program is initiated and even after the treatment is undergone.
• Facility Settlement (FS) is to settle out federal funds to facilities like Clinics, School Based Services (SBS), Hospitals and so on. Based on the contract, the payments are made monthly and at every fiscal year end the amount is settled out to these facilities. This is to ensure the all child facilities also get the amount as per the services provided based on the certifi - cations of services on that facility.
• Provider Enrollment (PE) will ensure that all the providers within the bubble of Medicaid program provided by the State of Michigan are enrolled with their valid National Provider Indicators (NPI).
• As a Senior Developer and a Team Lead for certain initiative projects and part of the core team, involved in Conversion activities that include auditing of source data, cleansing and transformation of source, loading into Data Warehouse, work­ing on tickets, maintenance of jobs using shell scripts. Also involved in migrating jobs from various versions of Datastage viz., 9.1 to 11.3 and 11.3 to 11.5.
• As CNSI started maintaining its own servers, as an admin and a SPOC, I am responsible for installation of IBM InfoSphere Information Server, and also admin related tasks like creating projects, assigning user roles, applying fix packs, start and stop of Information and Web Servers, NAS setup for huge data files, scripts to streamline certain maintenance activities and other migration related activities.
• As a senior developer and a SME, responsible for assigning tasks and monitoring the development of jobs in paral­lel with the development of jobs
• Solved tickets using Mercury Quality Center tool for ticket monitoring that needed technology expertise in conjunc­tion with Medicaid system knowledge
• As an Admin, communicated with Infrastructure and Database teams to raise access requests to get the server ready for Information Server installation, creation and maintenance of projects and users, maintenance scripts for cleanup and backup of server data and jobs for version control and disaster recovery, applying fix packs as part of monthly maintenance, debugging the server related issues and resolving it on priority basis involving IBM Technical Support team as and when required
• Involved in fit-gap sessions with State team that spearheaded smooth conversion, and design and update of the mapping documents
• As a part of data analysis for the initiative team, created jobs for the data load and detailed data reports for further analysis that involve Datastage, PL/SQL and R (basics). Data collected is later analyzed for any gaps in the exist­ing solution model and is presented to the state team to bring in more initiative projects to CNSI
• Involved in creating a model that uses IBM Watson and IBM Information Governance for future standardization of data analysis

Senior System Engineer

Confidential, Rocky Hill, CT

Responsibilities:

• As an Application Support/Operations Team member, I was involved in supporting application, debugging and fixing the issues within the SLA timelines. Applications supported by the team are DQM/QTNG, BMS, OCE, and HMA.
• Data Quality Management (DQM) is the application that is a part of the Ingenix Employer Solutions (IES) which now is a part of Optum. The processing group receives data feeds and processes them through well-defined steps before the data is loaded into Parallax-I tool enabling employers to run Analytic reports on their Healthcare costs and utilization for the vari­ous program areas.
• Clients and Carriers send Enrollment, Claims, and other data extracts to IES in their own layout known as raw input, which is used in transforming data source specific data file formats to an Ingenix Common Standard Format. Eligibility, Medical, Drug, Workforce Production, Lab and Health Risk are various subject areas that are part of the Data Quality and Data Man­agement capabilities.
• Responsible for fixing day to day issues that help keep the applications up and running. Issues involve Datastage, UNIX scripts, Oracle, Teradata, Microstrategy, SAS, Perl Modules, DQM application UI involving Client/Carrier/User profiles and their mappings.
• Solved tickets using HPALM tool for ticket monitoring that needed technology expertise in conjunction with industry and business knowledge
• Designed UNIX scripts for automated runs and the periodic mailer system
• Designed HP ALM scripts to customize the tools related tasks
• Involved in cross team communication with admins, sibling teams that use the application, users that run the appli­cations for support, maintenance and new releases

Environment: Datastage (ETL), UNIX Shell scripting, PL/SQL Developer, SAS, Oracle 12g, Teradata, HP ALM (For track­ing tickets), Citrix, Putty for AIX 5.2, Perl, Microstrategy

Senior System Engineer

Confidential

Responsibilities:

• As an Application Support Team member, I was responsible for supporting 6 Applications. I was involved in testing and deployment, enhancements of the existing code with the new requirements, debugging the code and fixing the issues with - in the SLA timelines of Common Wealth Bank, Australia. Applications supported are New DLMA, Phonetic Search, Ad­dress Search, Client Search, and Address ID Manager.
• DLMA (Data Load Matching Application) is responsible for managing thirty various products that use multiple platforms. Data that is received from various sources go through ETL process viz. Pre-Standardization, Standardization, De-Duplica­tion, Matching, and creation of Load files which loads into a centralized SAP database.
• Address ID Manager (AIM) process defines a common entry of an entry for the entire set of products and its customers. Phonetic Search and Address Search are the QualityStage based web services that helps customers search for the records in ComSee application.
• Responsible for effective communication between the project team and leads, project managers, customer. Pro­vide day to day direction to the project team and regular project status to the customer and onshore Technical lead
• Responsible for Datastage and also Shell scripting and Database supporting activities, also in developing One- timer jobs and scripts
• Utilize in-depth knowledge of functional and Technical experience in ServiceNow and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer
• Worked with XML files that were received as part of the web services that were running as for AddressSearch and NameSearch web services running from Datastage

Environment: Datastage (ETL), QualityStage, UNIX Shell scripting, Citrix, Putty for AIX 5.2, PL/SQL Developer, Oracle 11i, HP MyService Now tool (For tracking tickets)

Application Developer

Confidential

Responsibilities:

• Ensure that development is performed as per requirements and suggesting the required changes by developing and delivering new and complex high quality solutions to clients in response to varying business requirements
• Responsible for working with Data Modeller in creating a suitable model for the new solution proposed. Worked with Erwin tool on standardization of few models that were suggested by considering the reports generated from In­formation Analyzer
• Responsible for effective communication between the project team and leads, project managers, customer. Pro­vide day to day direction to the project team and regular project status to the customer and onshore Technical lead.
• Responsible for Datastage and also Shell scripting and Database Development activities
• Utilize in-depth knowledge of functional and Technical experience in ManageIT and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Environment: Datastage (ETL), QualityStage, UNIX Shell scripting, Citrix, Putty for AIX 5.2, PL/SQL Developer, Oracle 11i, Autosys, Erwin 4.0, IBM Information Analyzer

Associate System Engineer

Confidential

Responsibilities:

• USCL: The data from the Global sources (GCL) are loaded into the Warehouse systems. The data is surrogated and then extracted from the source and is applied with the business logic where the ETL tool comes into picture. Then, it is loaded into the warehouse. Since data is huge, Datastage is used to apply logics. Wrapping of all the processes is done using UNIX Shell scripts and the interfacing to the database is done using DB2
• Test Bed: This is the process that uses the Datastage tool to load the data from one environment to the other with password-less connection. An entry in the table is made where the script runs to move the data (Masking the pro­duction data to lessen the visibility of data)
• Merge Purge: This is the process for name matching and the address matching of the data. There is a script which wraps the process and the Merge Purge software does matching on data. This process generates the Household id of an individual customer of the address (Anything is unique). This is used in heavy analytics.
• Data Quality Analysis: This is the process that is entirely done in ETL (Datastage). The file which is received from the Mainframe is completely validated. It checks for the headers and trailers with the records’ counts and the sum of counts from the actual data.
• Data Retention: As per the business requirement, we were storing the data for the past 3 years till this project kicked off. However, this process stores data for the past 10 years without much change in the production process time by introducing the data partitions concept. At monthly refresh the data is loaded into the tables, considering all the past, present and the future data which cannot afford a loss.
• Addenda Data Analysis: The data which is sourced is of transactional data and also the addenda data (Data about the transaction type). This addenda data is profiled using Information Analyzer for the data’s consistency from which we derived to source the addenda data into Warehouse.
• Involved in creation of SRS, Mapping documents and rebuilding FSR documents
• Ensured that development is performed as per requirements
• Delivered reports using Information Analyzer that involved several Table and Column analysis for the low level de­sign of the Database
• Developed and delivered new and complex high quality solutions to clients in response to varying business require­ments
• Responsible for effective communication between the project team and leads, project managers, customer. Provid­ed day to day direction to the project team and regular project status to the customer and technical lead.
• Responsible for Datastage and also Shell scripting and Database Development activities
• Created test documents by listing test cases and logging them in Quality Center at the Unit/SIT/UAT Test phases
• Utilized in-depth knowledge of functional and technical experience in ManageIT and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer
• Developed reconciliation jobs and scripts for validating the data correctness

Environment: Datastage (ETL), Information Analyzer, UNIX Shell scripting, Citrix, Putty for AIX 5.2, IBM DB2, Mercury Quality Center, Control M