PROFESSIONAL STRENGTHS:

• Have more than 15 years of experience in IT industry
• More than 2 years of experience in Big Data technologies and Data analytics, utilized tools like Hadoop, Sqoop, Pig, Hive, Parquet, BIGSql and data engineered for Data sciences applications ( Python, R, SAS)
• 10 years of experience in data - warehouse technologies and in architecting, designing, developing and deploying projects
• Developed various architecture design through MS Visio for the applications and data flow
• Knowledgeable in Key consumer banking, retail and Product pricing in Banking domain
• Worked on recent acquisition project to move data to Hadoop platform from various sources like SQL-Server, Oracle, Sybase, Progress.
• Conducted POC projects in comparing tools like Ab Initio vs Sqoop, storage of data through parquet file and assessment of Ab Initio upgrades
• Led and managed technology teams with team size of 10 - 20 members
• In-depth knowledge of Technology skills and eager to learn new skills
• Experienced with tools: Ab- Initio (3.2), Hadoop, Sqoop, Unix, Teredata, Oracle, Sql-Server, MS- Project, MS-Visio, Python, R, C++

TECHNICAL SKILLS:

Management Tool: MS- Project

Design Tools: Enterprise Architect ver 5.0, Erwin 4.1, MS Visio

Big Data: Hadoop, Sqoop, BIGSql, Hive, Pig, Spark, Scala, Python

ETL Tools: Ab-Initio (GDE 1.14/1.15/3.0 Co>Op 2.14/2.15/3.0 , Conduct>It), SQL-DTS

RDBMS: Teradata, Oracle 11g, SQL-Server 2010

Languages: C++, COM/DCOM, Java

Operating Systems: Unix, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland

Technical Architect

• Managed technical team of size 12 members onshore and offshore
• Being a technical architect & lead, designed the data flow process from various data sources to Hadoop and choosing appropriate t0ol
• Worked along with Business Analyst to capture the requirements and mapping the information
• Designed the structure of the flow of data from various databases from Confidential systems
• Coordinated with Server teams to setup the firewall to access external servers
• POC conducted for Sqoop and Ab Initio to validate the performance and pros and cons
• Maintained task list for the delivery and maintained sharepoint site for the Project Technical information
• Created generic processes to extract and load process
• Received Certificate of Excellence for technical leadership of the project

Tools: Hadoop, Sqoop, Parquet, Hive, IBM BIG Insights, Ab Initio

Confidential, Cleveland

Data Architect

• Responsible for gathering the functional and non-functional specifications and documenting requirements
• Managed team members of 3-4 people at onshore and offshore
• Designed the data flow architecture and built AWS database in Teradata
• Data engineered for Data sciences applications and model
• Co-ordinating with various downstream teams to deliver the changes needed
• Responsible for identifying, analysing, measuring and managing project risks

Tools: Hadoop, IBM BIG Insights, Unix, Python, R, Sql-Server, MS Visio

Confidential, Cleveland

Technical Architect (Ab-Initio)

• Responsible for delivering the technical solution adhering to functional and non-functional specifications
• Gathering requirement from stakeholders and task allocation to the team
• Involved in technical design for ETL and optimization activities
• Accountable for adhering to committed project schedules
• Guide project teams through task execution
• Responsible for identifying, analysing, measuring and managing project risks

Tools: Ab-Initio GDE: 3.0.2 Co>Op: 3.0.2, SQL Server 2010

Confidential, Cleveland

Project Lead/Manager

• Involved in estimations for projects and TLA before on boarding to support
• Managed BDM support team and overall production support teams
• Involved in Ab-initio upgrade and Oracle upgrade for BDM and also for other Ab-Initio projects
• Involved in ETL design and code reviews
• Involved in performance tuning of the application
• Assisting the technical team in their design and development tasks

Tools: Ab-Initio GDE: 3.0.2 Co>Op: 3.0.2, Oracle 11g

Confidential, Chicago

Technical Lead

• Developed a new claims process, Involved in estimation of project budgets and cost
• Worked with Stakeholders in estimating the project effort and delivery timelines
• Led team of 8 to 10 members of Ab Initio technical team
• Involved in various POC activities, like extracting data from xml files and validating them.

Tools: Ab-Initio GDE: 3.0.1 Co>Op: 3.01, Oracle 10g, Solaris- Unix, Tivoli, Erwin

Confidential, Tampa

Senior DW Developer/Lead (Banking)

• Involved in architecting the Data acquisition project following SDLC process and developing the application with a team of 4 members.
• Scheduler process was developed through Ab-Intio Conduct>IT for file watching and running the process at scheduled time.
• Involved in writing unix shell scripts, like creating cron process to restart automated Conduct>IT processes, sftp process to collect data from source systems.
• Utilised BRE to generate xfrs, utilised within graphs and trained users to input the transformation logic which were created in BRE
• Written meta programming for generating dmls in runtime
• Created PL/SQL stored procedures to call from Join with DB component, also created triggers to updates process statuses for users
• Made performance tuning to various graphs in the application
• Involved in doing code review and doing performance check and suggesting performance enhancements to the graphs and resource utilisation
• Involved in scheduling tasks through latest Scheduler tool of Ab-Initio Dash>Board

Tools: Ab-Initio GDE:1.14/1.15 Co>op: 2.14/2.15/2.16 , Dash>board, BRE, Oracle 10g, People Soft (EPM), AIX- Unix, Erwin

Confidential

Analyst

• Integrating RTGS product for one of major (Reserve Bank of India) for their retail banking
• Worked with major telecom company (O2), Involved in designing and developing ETL application through Ab Initio, converting an existing SAS application
• Translated and mapped the functionality of the system to Ab Initio
• Optimized and Improved the performance of ETL process to provide effective results
• Migrated legacy applications from SAS to Ab-Initio for O2
• Designed Data migration strategy plan for transforming data from ERDF2000 (holds 11 State Aid information at different locations in UK) to ERDF2005 (centrally located web based system) for ODPM Project
• Analysing the data structure between both the systems and prepared a plan for transformations considering different issues like portability, duplication of data and reconciliation and created algorithms for transformation functionality
• Developed Mobile app for PDA device and maintaining for Britannia airways, iSQL-Anywhere was used as mobile db, which gets synced up to the server when the air crew reaches the base.
• SQL-Server DTS was used as ETL tool to transform data between Oracle databases to SQL-Server database, which involved writing PL/SQL procedures and creating in MIS reports using Business Objects
• Developed ATL-COM components for Corporate Data services with Anglian Water, and utilized tools like VC++, COM, ASP, Oracle

Tools: MS Visio, Enterprise Architect, Ab Initio 2.14, SAS, Java, VC++, C++, Crystal reports, SQL - Server, Oracle 91, Control-M, Business Objects, Unix, EA,