We provide IT Staff Augmentation Services!

Lead Etl Solution Architect / Agile Team Lead Resume

SUMMARY

  • A Lead ETL Solution Architect with over 13 years of strong IT experience in the field of Data Warehousing, Business Intelligence, Big Data and Cloud technology. Recognized & Awarded for Leadership, Solution Design and Operational Excellence. Areas of expertise include
  • Adept in ETL (Extraction Transformation Loading) Architecture, E2E solution design, Analytics Integration, Data Modelling, Operations, Orchestration, Report Development, Software implementation, configuration System Tuning, Cloud Pattern/Container Development, Services Portfolio, Financial Planning, Strategy and Resource Management
  • Adept in client - facing roles, provide innovative solutions to meet business and customer needs
  • Adept in Leading and managing team of 15 global resources (China, India, Brazil and Bratislava)
  • Adept at handling a high-pressure fast-paced work environment
  • SME of Confidential InfoSphere Information Server (IIS) suite products
  • 13+ years of strong ETL experience with IIS DataStage (6x,7.5,8.7,9.1,11.3,11.5), Information Analyzer (IA), Information Service Director (ISD), Master Data Management (MDM)
  • Experience in Software Architecture and Development on Confidential BlueMix and Confidential PureApplication Hybrid cloud environment; provide Platform As A Service (PaaS) applications for Confidential clients
  • Hands on experience with Hadoop Architecture and administration, HDFS file system, Ambari console, Big Insight
  • Adept in Agile SDLC with 2 years of experience as Scrum Master
  • SAP BW and HANA integration
  • Integration of various databases & software technologies such as DB2, Oracle,SQL server, Teradata Web Services, Netezza, SPSS, Kafka, Hadoop, Cloudant, Cognos 10x, Sybase, Tivoli
  • Extensive Experiences with SQL, PLSQL, Unix shell scripting, JSON, XML, Python, WSDL, REST, HTTP, J2EE, Kafka, WebSphere MQ, non SQL database, Hierarchical data
  • InfoSphere Data Architect, Visio, Erwin, Rational Team Concert, Clearcase, Microsoft Office

PROFESSIONAL EXPERIENCE

Lead ETL Solution Architect / Agile Team Lead

Confidential

Responsibilities:

  • As Lead Solution Architect & SME of IIS Technologies, I created number of POC processes, documented ETL rules & regulations with best practice, Mentored other architects and team members, design & performance improvements, Server migration support, software and fix packs upgrades testing planning and execution without any impact on development project life cycle, Solution Information Service Director (ISD) integration with Mobile devices
  • As Team Lead and Manager, I led and manage team of 12 Global resources. Developed and guided full Agile SDLC project plans to implement ETL solution, identify resource requirements and built harmony among team members
  • Designed and built re-usable Cloud patterns using Confidential ’s Bluemix & PureApplication Hybrid cloud platform to provide Platform As a Service (PaaS) for ESA back-end environments
  • Instrumental in Design, Development and testing number of ETL processes (around 2500 processes) using DataStage & Unix to source data from various sources such as RDBMS databases, Big data, Unstructured data, flat files, Hierarchical data, Kafka, Salesforce, Cognos reports, SPSS (Data Analytics environment) and Transform and Load those data in support of ESA Data Warehouse
  • POC work on SAP BW and HANA integration with DataStage environment
  • POC work on Big data, Hadoop framework, HDFS usage, Ambari console
  • Designed and implemented complex NRT (Near Real Time) solution to provide Opportunity related data to report writers 24x6 days, helps to reduce runtime from hours to 15 mins.
  • Enforced Agile Project methodology to increase the work performance and deliverables
  • Executed on GBS strategies through operational excellence, business value delivery, talent development, supporting attainment of Confidential CIO's objectives in operations, business model and growth

OS/Software skills : DW Architecture practices, IIS DataStage (7.5,8.7,9.1,11.5), ISD, InfoSphere Data Architect, Unix/AIX 7x, Confidential BlueMix, PureApplication Hybrid CLOUD Environment, SPSS, Python, DB2(7x,8x,9x), Netezza, WebSphere, MQ, Kafka, XML, JSON, Tivoli, Web Services, REST, HTTP, WSDL, RTC, SAP BW, HANA integration, Clear case, Oracle, SAP, Agile Methodology, MS Office, Visio, Hadoop, Ambari Console, Pig, Hive, BigInsight

Data Warehouse application revitalization

Confidential

Responsibilities:

  • As an ETL Solution Architect and SME of IIS technology, I led diverse teams of IT Specialists, Data Scientist and other Global Resources to deliver a complete solution with new hardware infrastructure, software version upgrades and legacy code updates to streamline data management design using newest IT language. Produce quality deliverables on time and within budget making Stakeholders and customers happy
  • Developed and guided full Agile SDLC project plans to implement ETL solution to merge multiple old DataMarts & Data Warehouse into meaningful Opportunity & Customer Star Data Warehouse with Pipeline Metrics information to our report writers and SRCoE
  • Led work efforts to sunset and convert old style & native ETL processes such as DB2 DWC processes, SQL stored procedure, java code, HiPer processes to High performance, high manageable and maintainable Datastage Processes on new high performance Confidential servers & PureApplication Hybrid Cloud environment. Designed and developed more than 5000 ETL processes in DataStage, DB2, Java and Unix which runs daily, weekly, monthly and quarterly
  • Build and trained team of global resources for ETL development, Testing and Operation support area to make very strong global team to be available for work and support 24 hours
  • Enforce team to follow best design, development, documentation, versioning control, operations support practice to follow Confidential ’s standard.
  • Encourage team for further education and promoted team to keep them motivated

OS/Software skills : IIS DataStage (6x,7.5,8.7,9.1,11.5), ISD, Unix/AIX 7x, PureApplication Hybrid CLOUD Environment, SPSS, DB2(7x,8x,9x), Netezza, WebSphere, MQ, XML, JSON, Cognos, Tivoli, Rational Team Concert (RTC), Clear case, DB2 DWC, Java, ODBC, InfoSphere Data Architect, Agile Methodology, MS Office, Visio, Erwin, DW Architecture practices

Software Engineer / ETL DataStage Consultant

Confidential, McLean, VA

Responsibilities:

  • As a Technical analyst & DataStage Developer, I worked on multiple projects primarily Corporate TAX, FIN Instrument to support their CDW (Corporate Data Warehouse).
  • Design and developed ETL processes to extract financial data from People Soft, SAP, Sybase and DB2 mainframe environments and loaded into DB2 UDB 8.1 CDW. Provided solution to improve performance by designing orchestrates (Parallel Extender) processes. Provided solution to execute jobs on production using trigger mechanism and to perform automatic data quality checks using Unix shell scripting, custom SQL and Autosys JIL scripts

OS/Software skills: 7.1/ 6.0 (Parallel Extender)/5.2, DB2 UDB 7.2/8.1, C, UNIX AIX/SP2, Autosys, Sybase, CleareCase, ClearQuest, MS Visio, MS office, Erwin

Graduate Research Assistant

Confidential, Washington, DC

Responsibilities:

  • Research work with Professor Confidential on Synthetic Aperture Radar (SAR) design improvement project funded by Office of Naval Research (ONR) USA
  • Administered IEEE Magnetic society website with constant enhancement to support yearly seminar under observation of Dr. Korman

Hire Now