Noopur Goel
*** * ******** **, *** ****, ARLINGTON, VA – 22203 +1-703-***-**** ac4n98@r.postjobfree.com
Professional Summary
3.5 years of IT experience as an ETL DataStage Developer
Proficient in all phases of Software Development Life Cycle (SDLC); Analysis, Design, Development, Testing, Implementation, and Maintenance
Experience with Data Warehousing concepts including Data flow diagrams, Database Normalization techniques and Entity Relationship Model for OLTP and Dimension Modeling for OLAP
Experienced in SQL to query the database using SQL Server Management Studio, UNIX, and UNIX Shell Script
Experience with scheduling jobs in AutoSys and creating JILs
Excellent communication, interpersonal, quick learning skills, analytical skills and strong ability to perform as part of a team
Motivated, Accountable, Ownership to deliver results, and experienced with Agile model
Work Experience
SR. PROGRAMMER ACCENTURE SERVICES PVT LTD NOV’13 – JUN’17
CLIENT: BANK OF AMERICA DEC’15 – JUN’17
Project Secured Card: To introduce a Secured Credit Card in US market targeting low FICO consumers
Tools: DataStage version 11.3, VI Editor, AutoSys
Languages: DB2, UNIX Shell Script
Coordinated with the front-end design team to provide them with the necessary timelines and insights into the data
Created project plans, schedules, and resolved technical issues -- Ensuring solution is in scope, on time and within budget
Conducted business walkthroughs to generate consensus, maintain quality, and resolve issues among different stakeholders during different stages of the SDLC with timely delivery against aggressive deadlines
Designed, developed, configured and deployed DataStage jobs, UNIX shell scripts and AutoSys JIL’s
Extensively used DataStage jobs for extracting, transforming and loading databases from different sources including DB2 and Flat files to target
Worked on DataStage components: Designer and Director to design parallel and sequence jobs
Used processing stages including Aggregator, Copy, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Pivot Enterprise, Transformer and Modify stages to develop parallel jobs
Debugged DataStage jobs using debug stages like peek, head, tail, row generator and column generator
Used both database and file stages including ODBC connector, DB2 connector, sequential file and datasets
Created sequence jobs to call different jobs from a single sequence job and send automated e-mail notification
Used different views in director to run, validate and resolve the warnings and errors in the jobs
Used AutoSys to schedule jobs, watch for the file to appear and call the UNIX shell scripts.
Created Job Information Language (JIL) to schedule jobs through AutoSys
Used Exception Handling extensively for ease of debugging and displaying the error messages in the application
Documented all the design, development and testing steps by creating documents like High Level and Low Level Design document (HLD/LLD), a code review checklist, technical specification and unit test document
Acted as POC for Application Development projects, conducted class room trainings sessions for new joiners, and mentored team members with product functionality and provided guidelines and solution on Performance tuning and techniques
CLIENT: QBE NA NOV’13 – DEC’15
Project TPA: The aim of the project was to consolidate direct claims and claims processed by Maddison consulting (TPA) for QBE NA
Tools: DataStage version 8.5, VI Editor, SQL Server Management Studio
Analyzed and Validated the TPA loss Run Report received from Maddison Consulting
Validated the policy in the Loss run Report against the Data Mart containing information on different policies
Had daily calls with the Client to understand their requirements and had them implemented following Agile methodology
Developed Extract, Transform and Load (ETL) modules based on design Specification, performed testing on ETL processes and resulting data warehouse/ad hoc tables, and successfully deployed those jobs
Created and Implemented both local and shared containers in DataStage jobs
Created sequence jobs to create a flow of data from source to target using different jobs
Fine-tuned SQL queries and validated data accuracy using SQL Server Management Studio
Successfully deployed the jobs in test environment and tested the jobs to function as expected
Conducted daily business walkthroughs with different stakeholders on project progress
Provided support in various phases of testing (Unit testing, System testing and Integration testing, UAT)
Created and maintained all the documentation related to developed objects which includes High Level and Low Level Design document (HLD/LLD), a code review checklist, technical specification and unit test document
Handled defects and change requests for the objects developed and deployed to production environment
Education
B.TECH. GALGOTIA – UTTAR PRADESH TECHNICAL UNIVERSITY, GRATER NOIDA, INDIA JUL’09 -JUN’13
Skills & Abilities
TECHNICAL SKILS
Tools: IBM DataStage and QualityStage, SQL Server Management Studio, VI Editor
Languages: DB2, UNIX
Scheduler: AutoSys
Recognitions
Received Stellar Award for Rising Star by Accenture; Recognized for Delivering excellence by Accenture