Data Architect Resume
CaliforniA
SUMMARY:
- Have experience more than 15+ years in IT industry and 10 years as Data architecture/ Data modelling in Big data and data warehouse systems
- Involved in various Data design and data migration process
- Have direct working experience of 12 years with banking clients at Confidential and Key Bank
- Has experience in Big Data technologies and Data analytics, utilized tools like Hadoop, Sqoop, Hive, Pig, Parquet, BIG SQL and data engineered for Data sciences applications (Python, R, SAS)
- 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
- In-depth knowledge of Technology skills and eager to learn new skills
- Experienced with tools: Ab- Initio (3.2), Hadoop, Sqoop, Unix, Teradata, 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 (ver 3.2), SQL-DTS
RDBMS: Teradata, Oracle 11g, SQL-Server 2010
Languages: C++, COM/DCOM, Python
Operating Systems: Unix, Windows XP
PROFESSIONAL EXPERIENCE:
Confidential, California
Data Architect
Responsibilities:
- Managed team size of around 35 members at onsite and offshore
- Setup Change management process for Hadoop applications
- Maintain various Bigdata applications and enhance applications
- Addressed various defects raised by business users and involved in enhancements of the code
- Performance tuning were made to Hive queries
Tools: MAPR Hadoop, Sqoop, Hive, Cassandra, Kafka, Spark, Python, R, Teradata, Tableau
Confidential, Cleveland
Data Architect
Responsibilities:
- Managed technical team of size 12 members
- Being a Data architect & lead, designed the data flow process from various data sources to Hadoop and choosing appropriate tool for data migration
- 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 FNFG 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
- Received of Excellence for technical leadership of the project
Tools: Hadoop, Sqoop, Parquet, Hive, IBM BIG Insights, Ab Initio
Confidential, Cleveland
Data Architect
Responsibilities:
- 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 analytical database in Teradata
- Data migration done from EDW database to analytical database for model development
- Data engineered for Data sciences applications and model
- Co-coordinating with various downstream teams to deliver the changes needed
- Responsible for identifying, analyzing, measuring and managing project risks
Tools: Hadoop, IBM BIG Insights, Unix, Python, R, SQL-Server, MS Visio
Confidential, Cleveland
Data Architect
Responsibilities:
- 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, analyzing, measuring and managing project risks
Tools: Ab-Initio GDE: 3.0.2 Co>Op: 3.0.2, SQL Server 2010
Confidential, Cleveland
Project Lead
Responsibilities:
- 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
Responsibilities:
- 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)
Responsibilities:
- 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.
- Utilized BRE to generate XFRS, utilized 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 utilization
- 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
System Analyst
Responsibilities:
- 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
- Analyzing 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, EAE-Share India, Integrated Enterprises, INDIA
