Etl Developer Resume
Professional Summary
- Over Sixyears of experience in Information Technology and Project Managment
- Certified Lean Six Sigma Green Belt & trained Black Belt
- Trained on Agile Scrum project Managment
- Well versed with Data warehouse and Business Intelligence
- Proficient in Informatica and Business Objects
- Proficient in evaluation of various ETL & BI tools., (PoC) work and presentations for various clients
- Worked with 'C' level at client implementation
- Expertised knowledge in Health care BI applications, and knowledge in Epic ,Cerner , Amsys, Facets, HpXr
- Trained on Successful Management Communication By Center for Leadership & Executive Development
- Done Independent study on Entrepreneurial Experiences under Robert Chelle Founding Director ,L. Crotty Center for Entrepreneurial Leadership
- Trained on Intellectual property (IP) by National Institute of Intellectual Property Management (NIIPM) , Central Government of India under the Ministry of Commerce & Industry
- Moderated Event at CEO National Conference
- Presented paper at Osmania university on Solar power satellite technology
- Presented paper on HVAC at KIET
- Won First Prize in " Everest Real Estate Challenge-2011"
- First Class trough out the career
- Creative in problem solving, quick and independent learning skills.
- Excellent Client Interaction, Communication & Presentation skills
Operating Systems
Microsoft Windows XP, UNIX
Software
C, Informatica,DWH, MS Project
Databases
Oracle, My SQL
ETL Tools
Informatica
Reporting
Business Objects
Work Summary:
- Working as Project Lead / Manager for Logan Bright consulting
- Worked for UDRI Center for Competitive change on Six sigma project
- Worked as Manager of facilitators for School of Engineering , Reported to Asst. Dean RiadAlakkad
- ETL Developer at I-Logic
- Worked as Trainer of Informatica, Business Objects , DWH at I-logic
- Worked as a freelancer Project Manager for PLANMANN in REDS 2006 project
- Worked as intern for VIAJAY ELECTRICALS Ltd
Work Experience:
Confidential, Sept 2011- Till date
Project Manager
Confidential, is an emerging data consulting service company in the New England area focused on providing services to clients infield of Data ware house/Business Intelligence , Data Integration,Data quality , Master Data Mangment with 15 clients
Responsibilites:
- Increased the companies growth by securing new partners,consulting engagements and by delivering new projects
- Successful project management experience (team of 15 to 20 people) for more than 1 year
- Good communication skills (reporting, people management) and good negotiation skills with client (ability to get requirement frozen, to detect changes and engage change request discussion)
- Hands on fixed price project management with commitment on budget and schedule (planification, progress follow up, estimate to complete)
- Risk assessment and mitigation action plan
- Project tools understanding (configuration documentation, requirement, test management tools)
- Planning, scheduling & execution of work for ensuring completion of Project on time & good quality compliance.
- Management & monitoring of team of Engineers for timely execution of project with good quality norms.
- Allotment of Work to team, directing & controlling them for quality execution of work.
- Preparation and Analysis of Daily Progress Report and Review for achieving Project Targets.
- Coordinating with different departments and ensuring project delivery as per schedule.
- Handling technical & commercial activities related to the project.
- Used Agile Scrum methodology forPoc
- Has experience in a medium or big company with a complex IT environment
Confidential, (Dayton, OH) May 2011- Sept 2011
Team member
Responsiblities
- Conducted process mapping and time/capability studies to improve, eliminate bottlenecks and ensure adherence to customer specifications
- Liased between design, manufacturing and executive teams as a contributor to development of rings.Ensured product manufacutablity ,robust design ,compliance with regulatory requirments and transition from proto type to production
- Applied core statistical methods for collecting and analyzing of data
- Performed failure mode and effects analysis and a variance of analysis
EGR Manager (Dayton, OH) (Feb 2010 - May 2011 )
Confidential
Responsibilities
- Oversee planning , implementation , supervision of tutoring program
- Promoting and maintain positive relation ship between the students and faclitators
- Coordinate the enrollment ,matching and scheduling of tutors and students
- Establish overall policies and procdure of the program
- Support Undergraduate Engineering students in completing their assignments and projects in time of need
- Enhance the academic experience of freshmen engineering students in various math and science courses
- Taking care for running the session smoothly by direct monitioring
Confidential, (Jan 2008 - Dec 2009)
ETL Developer/ Trainer
Worked on Multiple project
Responsibilities
- Done extensive testing and wrote queries in SQL to ensure the loading of the data.
- Performed unit testing at various levels of the ETL.
- Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
- Fixed the invalid mapping\'s and troubleshoot the technical problems of the database.
- Debuged the sessions by utilizing the logs of the sessions.
- Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
- Worked extensively with complex mapping using expressions, aggregators , filters, lookup and procedures to feed the datawarehouse
- Created the Worklets , Tasks, Timers,Reusable objects for scheduling workflows
- Used Informatica (Repository Manager) to give permissions to users, create new users, repositories
- Developed Reusable Transformations & Mapplet and used them in the Mapping
- Performed data gap analysis from source systems to target elements and also from target elements to reporting elements
- Did Impact analysis on various source tables
- Implemented the Slowly Changing Dimension strategy for the Warehouse
- Maintained warehouse metadata, naming standards and warehouse standards for future application development
Environment: Informatica,Business Objects , Windows and HP-UNIX
Confidential, (Nov 2006 - Dec 2007)
Project Lead
Worked on Multiple project
Responsibilities
- Done extensive testing and wrote queries in SQL
- Worked as a freelance Project Manger /Leadfor REDS-2006
- Involved in building local teams at every village by studying the needs, training and allocating work for the team members ,supervising , supporting the team for improving the quality
- Supported the Senior market research analyst for the collection of data
- Assisted in project scheduling and operating
- Worked at 3 different site locations covering the complete project
Education : MS