SUMMARY

• Senior management Solutions Architect with 14+ years of IT experience in Account management, Business Requirements Analysis, Application Design, Development, Implementations, Testing & Support of Data Warehousing business systems for highly regulated industries such as Banking & Finance and Healthcare.
• Proficient in designing ETL solutions, from estimation to deployment and support phase of projects, to meet business challenges and objectives and leading software development teams.

TECHNICAL SKILLS

• Project management & delivery
• Solution Architecture
• ETL
• RDBMS
• Leadership
• Mentoring
• Agile methodologies
• Ab Initio suite of products
• Unix Scripting
• QA
• Hadoop Intergration
• Database (Oracle, Teradata, DB2, SQL Server, MySQL, Sybase Netezza, etc.)
• Big Data (Sqoop, Hive, HDFS, Python, HBase, Spark, Scala)
• Autosys/Control M/Airflow
• ServiceNow, Jira
• Git

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Build new Big Data as well as Ab Initio applications from scratch and deliver in Agile methodology
• Conduct PoCs using to download data from different databases to Datalake tenant using Spark, Sqoop, Hive and Hadoop maintaining data security and privacy
• Provide engineering and design support for Hadoop/Spark/Ingestion Tool based build, configuration, monitoring and supportability
• Conduct knowledge transition (Hands - on) sessions for project team to build Big Data capabilities and own a new framework built using Spark (Scala), Python & Unix Scripts
• Provide architectural direction to team members, mission critical work streams and work within the agile framework
• Design complex applications in Express>It from scratch and deliver high quality deliverables in aggressive timelines
• Build strong relationships with key customer stakeholders to advise, partner, and drive execution
• Co-ordinate with business partners and offshore to ensure successful and timely completion of deliverables
• Profile and analyse data to understand it better and design the ETL applications accordingly
• Created automated scripts for tagging code to send email to teams for tag object analysis
• Design and build reusable components to enable quicker build of code
• Implemented architectural improvements and designed solutions for better performance and scalability
• Managed design, development, testing and warranty support of projects to deliver complete application to delight of customers
• Recommended best practices to CoE team for code validation, tagging and deployments

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 the project was preferred over other projects and selected as the first one to be audited in CMMi level 3 external audit
• Played role of Technical Application owner of Global Reference Repository and helped business design and build critical aspects of the application including enhancing its capabilities
• 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
• Formation and implementation of Ab Initio CoE including creating training plans and conducting training programs designed to train resources with varying levels of skillsets
• 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
• Engaged review sessions with various stakeholders in project
• Mentored 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
• Worked with peers and managers to ensure assignment deadlines are communicated and being met
• Managed and/or developed code with team along with extensive unit testing
• Got design and code reviewed and signed-off by architect and CoE teams
• Migrated code to testing environment and supported system integration and user acceptance testing
• Trained in Informatica, Big Data and Hadoop basics, 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
• Helped create Ab Initio training program and trained resources to build ETL capabilities of the team
• Created LLD and conferred with architects and key stakeholders
• Co-ordinated application development activities with offshore development and testing teams and ensured timely closure of defects
• Defined timelines of development and testing activities and ensured adherence to project timelines
• Profiled source data before beginning development to better design the application
• Defined data quality rules in discussion with the business users
• Led process improvements using automation to streamline repetitive tasks saving time and effort for development and/or business community thereby improving efficiency by 30%