SUMMARY

• Over 20 years of total IT experience in analysis, architecture, design, development, testing, implementation, maintenance and documentation of various applications in all phases of project life cycle.
• 12+ years of experience in the field of Data warehousing/Data Integration implementing ETL based solutions.
• Hands - on 15+ years of experience on Ab Initio ETL tool, Data Mapping, extracting, transforming and loading data in complex, high-volume environments.
• Hands-on 1+ year of experience on Informatica ETL tool and Microsoft SSIS.
• 7+ years of experience in team management leading teams of various sizes (largest team size 20) from requirement gathering through to implementation.
• Expertise in UNIX shell scripting, Oracle PL/SQL
• Visualizing data using Tableau.
• Profile and Analyze simple to complex data usage using Ab Initio Data Quality Environment (DQE) or Data profiler
• Hands-on experience on Ab Initio DQE, ACE, BRE, Metadata Hub, Express->IT and Query>IT tools.
• Performance tuning the complex Ab Initio graph, used Ab Initio best practice approach to implement the ETL process
• Configured graph parameters, sandbox parameters, environment variables and EME Metadata Repository environment for Production/Development and performance tuning for load graph process.
• Involved in data migration programs between database like Oracle, SQL Server and DB2, Teradata and PC file formats and added enhancements to existing applications according to regulatory requirements.
• Proficient with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and MFS techniques.
• Experienced in Job scheduling tools like Control-M, Autosys, Dollar Universe, Ab Initio Operation Console
• Experienced in writing complex SQL queries to perform the Back End Testing and Database Testing of the Oracle database using SQL
• Experience in testing database applications of RDBMS in ORACLE, DB2, Teradata, SQL Server, Netezza and MS Access.
• Have in-depth knowledge on Big Data technologies such as Hadoop query languages including Pig, Hive etc. along with alternative HDFS-based computing frameworks including Spark.
• Good Communication Skills and Strong interpersonal skills to deal effectively with a broad range of contacts from technical staff, to clients, to management.
• Exceptional focus, follow-through and coordination skills. Proven ability to manage project schedules, and known for working well with cross-functional teams to achieve on-time project completion.
• Strong problem-solver who can design solutions and assist developers with issues.
• Quick learner. Can pick up new concepts and technology very quickly and apply them effectively at work.
• Experience working as a Technical Lead and Business Analyst in Telecom, Banking and Travel areas.
• Strong Interpersonal and communication skills, ability to work in a team as well as independently with minimal supervision
• Very methodical and well organized with excellent bottom-line for work
• Sound experience in System analysis, design, and development using waterfall or agile methodology
• Good understanding of design patterns
• Motivated problem solver with strong analytical skills
• A quick learner, punctual and trustworthy
• A capable and resourceful team member who also possesses excellent written and verbal communication skills

TECHNICAL SKILLS

ETL Tools: Ab Initio, Informatica, DataStage

Scripting languages: Korn shell, PL/SQL

Databases: Oracle, DB2 UDB, Teradata, SQL Server, Netezza

Languages: Packages

SQL, Visual Basic, Visual C# (C Sharp): Oracle Forms and Reports, SQL*Loader, PL/SQL Developer

Operating Systems: UNIX, AIX, Windows 98/XP/NT, Windows NT 4.0, Windows 2000 and Sun Solaris

Other Softwares: Tableau, Microsoft Office, Microsoft Visio, Microsoft Project, Siebel CRM

Domain Knowledge: Telecom, Banking, Retail, Insurance and Maintenance Aviation

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential, Dallas, TX

Responsibilities:

• Carry out a system ‘deep-dive’ review and analysis to develop source to target mapping documents which will be used to build data migration codes
• Profile and analyze Source data from multiple strategic sources using the Ab Initio ETL Data Quality Environment (DQE) tool
• Identify data migration themes and quality patterns presented in the data and be able to provide a summary supporting the empirical data findings using Tableau.
• Communicate and engage with Client Business and Client Vendor(s) Technical resources.
• Define ETL Strategy
• Lead the team technically
• Develop Ab Initio code and required scripts that will extract data from legacy source systems, apply the business rules, transform into target format and load them into target systems.

Environment: Ab Initio (GDE 3.2.5.1 Co>Operating System 3.2.5), Oracle (Version 11g), UNIX Shell Script

ETL Lead

Confidential

Responsibilities:

• Be able to extract data from different kind of sources; structured data like RDBMS or unstructured data such as logs, recordings, recordings, documents etc.
• Can be configured to replicate data on near real time basis like in every 5 minutes or in batch mode like in every 4 hours.
• Should not lose any data while replicating
• Analysis, Design and development of business requirements
• Interact closely with Architects, data Modelers and Business Analyst during design sessions
• Develop custom specific and generic graphs to load and unload data from Oracle/Netezza databases
• Design, coding and writing and testing complex ETL application programs using Ab Initio tool
• Performance tuning of Ab Initio graphs processes and implement Ab Initio best practices throughout the development phase
• Develop UNIX shell wrapper scripts and supporting the testing effort
• Test and enhance the application by developing automated test scripts, product deployment, methodologies, application support and bug fixing.
• Work with production support team to execute and monitor the production jobs through scheduler
• On-call support
• Guide and help other employees of the organization to learn Ab initio and its best practices.

Environment: Ab Initio (GDE 3.2.4.2 Co>Operating System 3.2.4), MSSQL 9.0, Oracle (Version 11g), UNIX Shell Script