Sign in

Sql Server Project

Arlington, Virginia, United States
March 02, 2018

Contact this candidate

Noopur Goel

*** * ******** **, *** ****, ARLINGTON, VA – 22203 +1 703 *** ****

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



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


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



Skills & Abilities


Tools: IBM DataStage and QualityStage, SQL Server Management Studio, VI Editor

Languages: DB2, UNIX

Scheduler: AutoSys


Received Stellar Award for Rising Star by Accenture; Recognized for Delivering excellence by Accenture

Contact this candidate