SUMMARY

• ITIL certified professional with 13+ years of experience in Business Intelligence, Data Warehousing, ETL applications and Ab Initio suite of products.
• I complement my experience in leading software development teams, from design to deployment and support phase of projects, with strong analytical and communication skills.
• I also have experience of leading teams in onsite - offshore model and exploring new business and development opportunities with clients
• 13+ years of experience in the IT industry developing Data Warehouse applications in Ab Initio
• Extensive experience in analysing, designing, building and testing complex ETL applications show casing strong data integration skills in a team-based software development lifecycle and familiarity working with remote clients
• Expert in building complex applications from scratch and delivering high quality code
• Successfully managed projects at onsite location interacting directly with the client managing and co-coordinating development activities with the offshore team as well as Agile methodologies
• Experience in requirement analysis, estimation, project planning and tracking, resource allocation, etc.
• Exposure to data profiling, data quality and data analysis
• Analysed data extensively to design and build a robust and scalable application
• Extensively used Web EME for dependency analysis and version differences.
• Have good exposure to Express>It, Continuous Flows, Micrographs, custom components, Conduct>It, psets, MFS file systems, AI queues, PDL programming, custom functions, etc.
• Strong working knowledge in unix (automating executions, wrapper scripts, etc.) and sql languages along with exposure to Oracle, Sybase and SQL Server databases.
• Good understanding of business requirements, goals, and risks in order to formulate and define the technical scope and objectives of projects, requirements gathering, creation of high level and low level design documents.
• Expertise in managing end to end development and maintenance projects that involved activities ranging from development from scratch to implementation and warranty support.
• Excellent communication, analytical and reasoning skills complemented by leadership and interpersonal skills.
• An effective leader with proven abilities in leading teams during the project phase and guiding team members and enabling knowledge sharing amongst the team.
• Knowledge in Informatica, Big Data and Hadoop (sqoop and hive)
• Project management, effort estimation, project planning, resource forecasting, stakeholder management
• Interact with business users to discuss, analyse and finalize requirements.
• Issue identification and resolution during testing as well as post production implementation.
• Design, build, test and implement end-to-end robust ETL and DW applications as per the business requirements.
• Work on the Onsite-Offshore model representing the team at client location.
• Co-ordinate application development activities with the offshore development and testing teams and ensure timely closure of defects.
• Define timelines of the development and testing activities and ensure timely strict adherence to project timelines.
• Prepare list of all deliverables for project and ensure production implementation without any issues.
• Train and mentor new team members to bring them up to speed.
• Provide solutions to improve the efficiency and performance of existing applications.
• Manage ETL code approval process and migration of code to production environment.

PROFESSIONAL EXPERIENCE

Confidential

Managing Consultant

Responsibilities:

• Build new applications from scratch and deliver in Agile methodology
• Manage successful delivery of projects
• Design applications in Express>It from scratch and deliver high quality deliverables in aggressive timelines
• Interact with business users to discuss, analyse and finalize requirements
• Co-ordinate with business partners and offshore to ensure successful and timely completion of deliverables
• Analyse requirements and prepare functional and technical specification document

Confidential

Technical Leader

Responsibilities:

• Took up additional responsibility of project management for CMMi level 3 audit and certification
• Converted the status from red to green in CMMi certification prep audits and project was the first project to be audited in CMMi level 3 external audits
• Manage a 400K healthcare project housed in UK and India and has users spanning across globe
• Involved in project management, effort estimation, project planning, resource forecasting, stakeholder management, project tracking and monitoring
• Create and maintain project plans communicating milestones, issues, resolutions and escalations to all stake holders
• Responsible for people management, including goal setting and providing performance feedback for a team of 11 people
• Turned around the project to reduce project timeline by 20% and progress even with high attrition of experienced people in the team
• Managed development and testing teams to work as one project team by improving coordination and resolving conflicts
• Design, build, test and implement end-to-end robust ETL and DW applications as per the business requirements
• Streamline processes related to design, development, review and migrations
• Formation and implementation of Ab Initio CoE including creating training plans and conducting training programs specifically for different levels
• Trained in Hadoop, Hive, Pig, Spark, HBASE, etc.

Confidential

Ab Initio Tech Lead

Responsibilities:

• Follow the SDLC life cycle model for projects in managed services engagement
• Managed L0 estimates for work order after initial analysis using units of work following the WBS methodology
• Engage review sessions with various stakeholders in project
• Mentor and lead team members on process and development activities and deliverables
• Lead initial discussions with business and technical SMEs on understanding requirement and getting sign-off on functional and technical design documents and solutions to ensure application meets business and performance requirements
• Work with peers and manager to ensure assignment deadlines are communicated and being met
• Manage and/or develop code with team along with extensive unit testing
• Get design and code reviewed and sign-offed by architect and CoE teams
• Migrate code to testing environment and support system integration and user acceptance testing
• Trained in Informatica, Big Data and Hadoop, Agile methodology, Scrum Master, etc.

Confidential

Ab Initio Lead & Specialist

Responsibilities:

• Worked with Confidential as senior Ab Initio consultant for end-to-end data warehousing projects
• Create LLD and discuss it with architects and stakeholders
• Co-ordinate application development activities with offshore development and testing teams and ensure timely closure of defects
• Define timelines of development and testing activities and ensure adherence to project timelines
• Create star schema like architecture for application
• Profile source data before beginning development to better design the application
• Define data quality rules in discussion with the business users
• Provide solutions to improve efficiency and performance of existing applications
• Create processes/automated tools to streamline repetitive tasks saving time and effort for development and/or business community. These tools improved efficiency by 30%