Sr. Programmer Resume
4.00/5 (Submit Your Rating)
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
TECHNICAL SKILS
Tools: IBM DataStage and QualityStage, SQL Server Management Studio, VI Editor
Languages: DB2, UNIX
Scheduler: AutoSys
WORK EXPERIENCE:
Sr. PROGRAMMER
Confidential
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
Confidential
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