More Related Content
What's hot (20)
Viewers also liked (8)
Similar to Nitin - Data Specialist (20)
Nitin - Data Specialist
- 1. CURRICULAM VITAE NITIN E-mail: nitinsinghal88@gmail.com Gurgaon, Haryana (India) Contact no: (+91) 958-205-7305 Summary Around 6.5 Yrs Experience of development & maintenance in the IT industry including US Health Care Industry. Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using IBM Datastage 7x and 8x and build Datawarehouse,Operational Data Stores and Data marts. Experience in Design and implementation. Handled multiple roles Lead developer, Senior Programmer, Developer and Analyst. Strong work experience in performing ETL techniques to load data from different sources (DB2, Teradata, SQL server, Flat files, XMLs and Excel files) into data marts and data warehouse using IBM Datastage tool. Good exposure in Data Analysis, Data Cleansing, and Transformation, Integration, Data import, Data export. Expert in unit testing, system integration testing, implementation, maintenance and performance tuning. Extensive experience with analysis, design, development, customizations and implementation of software applications in Data warehousing, Data Integration, Data Processing and Business Intelligence. Possess excellent communication skills and a performance oriented team player with Good analytical, design skills, and problem solving abilities. Diverse background with fast learning skills and creative analytical skills and Good problem solving skills with a strong technical background and good Interpersonal skills. Solid management skills, in the very early period of career, demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity, while forming cohesive team environments. Experience in leading and managing teams internally Software Proficiency/Technical Expertise ETL Tools : IBM Datastage 8.7/8.5/8.1/7.5 (GRID), Information Analyzer, Server/Parallel Routines Database : Db2,Teradata, MS Access Operating Systems : Vista,Window7/XP Professional,Linux, Unix Programming : PL/SQL, SQL, Unix Shell Scripting,C,C++ Scheduling Tools : Autosys, Tivoli workload Scheduler (TWS) Utilities : Putty, Ultra Edit,Reflex Quality Tools : ALM Miscellaneous : DB2 Command Center, HPSM, CITRIX, Teradata Client,Toad Achievements & Extra Curricular Activities
- 2. Received Two Recognition Sustaining Edge Award from Senior UHG management, for designing and developing suitable solutions for many projects. Received Three Recognition Star Award (SPOT) from Senior UHG management, for designing and developing a customized solution for clearing all production defects and delivered the defect free code with in very critical time lines. Received Two Recognition Pat On Back Award from Senior UHG management, extending my limits and completed the client requirement with in very critical time lines. Received One Recognition Best Team Award from Senior UHG management, for outstanding team work and project support for long span of time. Active member of Internal Food committee in UHG. Technical Event organizer as well as coordinator at organization level. Event organizer in school and college annual day functions and other technical events Professional Experience Jan2015 to till Date, United Health Group, Gurgaon as Senior Apps Developer/Data Analyst. Sep2011 to Jan2015, United Health Group, Gurgaon as Apps Developer. June2010 to Sep2011, United Health Group, Gurgaon as Associate Apps Developer. Educational Qualifications Bachelor of Technology (CSE) from BMIET, Sonipat in First Division (2005-2009) 12th from CBSE Board (2005) 10th from CBSE Board (2003) Project Experience Project: EHB Vision Dental Reporting Client: UHG Inhouse Company: United Health Group Period: Jul16 Till Date ------------------------------------------------------------------------------------------------------------------------- Project: NICE Custom Network - Galaxy Only Client: UHG Inhouse Company: United Health Group Period: Mar16 Jul16 ------------------------------------------------------------------------------------------------------------------------ Project: Galaxy Local LOINC Cd Mapping Client: OPTUM Inc. (Product Unit of United Health Group) Company: United Health Group Period: Sep15 Feb16 ------------------------------------------------------------------------------------------------------------------------- Project: ICD10_Compliance & Neutrality - COSMOS Client: UHG Inhouse Company: United Health Group Period: May15 Aug15 -------------------------------------------------------------------------------------------------------------------------- Project: Work force Managment Client: UHG Inhouse Company: United Health Group Period: Dec14 Apr15 ------------------------------------------------------------------------------------------------------------------------- Project: UHC E&I/M&R Risk Adjustments Client: Cornerstone
- 3. Company: United Health Group Period: Mar14 Nov14 ------------------------------------------------------------------------------------------------------------------------- Project: Lab Specimen Number expansion Client: Quest, South Bend Medical, Westmed Medical lab Groups Company: United Health Group Period: Oct13 Feb14 ------------------------------------------------------------------------------------------------------------------------- Project: UHC M&R Client: Smapson Company: United Health Group Period: Apr13 Sep13 ------------------------------------------------------------------------------------------------------------------------- Project: HCR Exchange CDB Client: CDB Company: United Health Group Period: Oct12 Mar13 ------------------------------------------------------------------------------------------------------------------------- Project: Galaxy, UGAP and UCG Application Client: UHG Inhouse support/Maintainance project Company: United Health Group Period: June10 Sep12 ------------------------------------------------------------------------------------------------------------------------- Roles & Responsibilities: Involved in various phases of implementation for a project starting from Requirement Gathering and Analysis, Development, User Acceptance Testing to Implementation in Production. Involved in communication with the Business Analysts for business requirements analysis and risk mitigation process. Developed the entire batch schedule for all the datastage jobs using Tivoli workload Scheduler/Autosys 7.5. Fine-tuned the datastage process to improve the performance of the ETL process. Data integrity between the various source tables and relationships. Designing scripts, Flowcharts and data flow diagrams. Populated slowly changing dimensions tables using type 2-dimension changing and maintaining the full history of the data. Created Unix Scripts for some of the ETL s as per the requirement. Involving in analyzing the Functional spec and preparing low level design based on impact analysis. Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data on Db2. Involved in production deployment planning and implementation. Worked on Production Tickets created by users for their critical requirements. Worked on enhancement and migration (datastage 7.5 to 8.7) projects. Worked on scheduler migration (Autosys to TWS migration) projects. Supporting critical periodic activities like Purge & Archive Analysis & resolution of production job failures within SLAs Handling Data Reconciliation and Maintaining Data Quality. Leading Teams in different projects as per requirement. Responsible for the On-boarding process involving Knowledge Transfer, knowledge building, presentations and code walk-through. Personal Attributes
- 4. Confident, enthusiastic, good inter-personal skills & effective team member. A self-starter-Initiative, quick learner and ability to organize plan and achieve goals. Ability to think broadly and conceptually while handling details well. Visualize complex situations in a simplified manner. Ability & Inclination to communicate openly & honestly. Penchant for sharing information and transferring knowledge. Declaration I hereby declare that the above written particulars are true to the best of my knowledge and belief. Place: Gurgaon Nitin