We provide IT Staff Augmentation Services!

Solution Architect/senior Datastage Developer Resume

5.00/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY

  • 12+ years of experience in IT industry, having professional experience in Data Warehousing (DWH) and Business Intelligence (BI) tools and Applications, Commercial/Business application software development, Client Server/Web applications and Software Development Life Cycle (SDLC) phases.
  • Hands on experience in working with Ecosystems like Hive, Pig, Sqoop.
  • Hands on working knowledge of current and pipeline technologies; BI Semantics, Data Quality Services, Big Data (Hadoop), Pig, NoSQL (CouchDB - cloudant, Hive), OBIEE, IBM Cognos reporting, metrics\KPI\scorecard driven analytics and management.
  • Experience in Peopletools and Peoplecode.
  • Information Architect for Data Warehouse (DW) and Business Intelligence (BI) projects, expertise in the design, data modeling methodologies and development for n-tier data warehouses.
  • Hands on implementer/Integration of MDM, Data Governance solutions to provide a single version of the truth to be used throughout the organization
  • Unique ability to understand and long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
  • Lead staff from 5 to 10 people including onsite and offshore resources.
  • Goaled towards project deliverables which added value to increase client retention, audit compliance and 99.99% SLA meet.
  • Project Lead for 7 simultaneous DW/BI development efforts for the various industries. Led weekly project status meeting with both client and project team to track progress toward established milestones. Proactively addressed client issues and concerns, set client expectations, and ensured customer satisfaction.
  • Defined and built Information Management Practice, hired and trained technical team; provided training to different business functions and done presentations of new visualization tools.
  • Worked in partnership with different business functions to support regulatory, BI, and other Reporting needs. Lead full project life cycle development to provide an N- tier data and reporting solution including Business Case, ROI, Analysis, BRD, Data quality/Mining, Use Cases, Testing, Implementation, and Enhancements.
  • Hands on Project Manager / Lead of the ETL & Reporting team, including product evaluation, training, architecture, and team management.
  • Architecting ETL Framework which tracks process metadata like execution, time, number of records, control reports, and provide detailed error identification.
  • Advanced development knowledge and hands-on skills in integrating SQL Server Oracle, T-SQL,and SharePoint Server and Services
  • ETL technologies Datastage, Informatica, Talend & OWB
  • Owned\lead Design, Development, Deployment, Training and Support of Data visualization platform like OBIEE, Siebel Analystics,Cognos, discoverer 10g and data query systems for standardized corporate reporting and self-service BI,
  • Supporting Teradata based platform.
  • Part of Data Governance office, which includes end-to-end process and data quality framework creator for assessing decisions that ensure the suitability of data for its intended purpose.
  • Hands on integrating MDM solution in BI.
  • Lead DW\BI requirements, build Bus Matrix, identify and document Conformed Dimensions and Measures, and revised Project Plan for ETL load and analytics initiative
  • Lead client’s Financial Reporting initiative to re-engineer Web base meta-data portal integrating with SharePoint.
  • Project lead and full SDLC architectural design and review for Data Management and Operations.
  • Performed extensive Data Mining analysis on Analyst/Management queries and usage to improve performance and provide batch reporting and identify risks and problems when they first appeared.
  • Logical and physical data modeling using Visio/ Erwin / OLAP Data Modeling, Relational / OLTP modeling and process/data/systems flow development/ documentation to illustrate current and future end states.

TECHNICAL SKILLS

Languages: Peoplecode, C,PlSql,Hive,Pig

ERP: Confidential HRMS,FMS,SCM Applications,EBS, Siebel, SAP

DI Tools: Datastage Server, EE Edition, Business Glossary, FastTrack, Information Analyzer, Informatica, Talend, OWB.

Business Intelligence Tools: Oracle Business Intelligence Enterprise Ed.(aka Siebel Analytics - OBIEE),Cognos 10.1.1, Business Objects 6.5, Oracle BI Discoverer 10g

Database: ORACLE,Exadata, Teradata, Cloudant NoSql, Hbase,SQL Server2000,DB2/OS390

PROFESSIONAL EXPERIENCE

Confidential

Environment: Datastage Parallel 11.3, OBIEE, Oracle, Teradata.

Solution Architect/Senior Datastage Developer

Responsibilities:

  • Managing and coaching a team of six developers. Together, we are tasked with maintaining and enhancing numerous internal business-facing data ETL jobs and reporting processes.
  • Responsible for understanding the scope of the project and requirement gathering.
  • Involved in analysis, design,construction and testing of the application.
  • Developing and maintaining full ETL codebases in database environments - A full Oracle Data Warehouse implementation, both consisting of multiple Windows/UNIX development, test and production servers and virtual machines.
  • Maintaining large data sets and troubleshooting existing ETL processes to ensure data integrity and quality. Modules involved include HR/payroll - Confidential, Kronos, TESS, Active Directory and Demantra.
  • Designed Data Architecture, Data Modeling and ETL Architecture/Design.
  • Reviewed ETL jobs to improve jobs performance, added appropriate stages for optimization
  • Worked on Parallel Jobs using Various Stages like Sequential File, DataSet, Lookup, Join, Aggregator, Remove Duplicate, Modify, XML, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Store Procedure Stage, Transformer, Teradata/MS-SQLDB2/Oracle Connector stages.
  • Coordinated upgrades and maintenance on licensed software with external vendors and arranged for training and demonstration of new features.
  • Resource allocation, project prioritization/management and contribution to large-scale software development projects to enhance business visibility and functionality into internal data analytics using OBIEE and Datastage.
  • Modeled .rpd as per business need.
  • Developed UNIX scripts to trigger the Datastage jobs.
  • Develop STMs (Source to Target Mapping) documents with business transformation logic.
  • Created Datastage job templates for faster and efficient development.
  • Created OBIEE dashboard’s/reports as needed.
  • Created a detail plan for historical data load, developed scripts and managed its execution
  • Developing business oriented dashboards and analytics in business intelligence tool.

Confidential

Environment: Datastage Parallel 9.1, Exadata, Couch DB/Cloudant, Python, AIX, DB2-BLU.

Solution Architect/ Senior Datastage Developer

Responsibilities:

  • Actively participate with client to prepare business requirements through SCRUM sessions and understand client needs.
  • Gather and prepare analysis based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency.
  • Responsible for overall data conversion from requirements gathering to successful load of data into production.
  • Designed Data Architecture, Data Modelling and ETL Designs.
  • Create PoC (proof of concept) jobs to give a walkthrough and to finalize the design.
  • Lead design of Data conversion, mapping and staging strategy for multiple streams of data.
  • Maintain detailed issues and action items list throughout the implementation, while documenting requirements and addressing operation process issues to accomplish business objectives, determining required changes and their impact.
  • Assist PM in planning and driving low level project tasks.
  • Prepare technical specification for data cleansing/standardization/conversion.
  • Work closely with business analysts and solution architects to implement best-of-class MDM and ETL solutions.
  • Created a detail implemented plan, coordination with different teams on implementation of common jobs and deployment of ETL jobs, UNIX scripts, Control-M jobs and DB objects
  • Developed BI publisher reports for legacy reports.
  • Document Data standards and data quality for accurate reconciliation.
  • Handle multiple file formats - Flat Files, JSON and XML.
  • Load data into Couch DB / Cloudant Cloud Databases using python scripts.
  • Integrated AD data into Datastage for security.
  • Ensured data conversion impact on the business is minimized.
  • Analyze error logs and extraction programs for data fallout and cleanup.
  • Perform code review for ETL team code assets.
  • Mentor offshore for delivery of quality code.
  • Created a detail plan for historical data load, developed scripts and managed its execution.
  • Co-ordinate with QA/UAT for timely delivery to production.
  • Communicate project status and technology issues to sponsors stakeholders and senior management.

Confidential

Environment: Datastage Server 8.5 on AIX, OBIEE 11g, Exadata

EPM Solution Architect/ Senior Datastage Developer

Responsibilities:

  • Participated in multi organizational, multi disciplinary teams to determine, articulate, & codify business requirements.
  • Lead & managed Disaster recovery & Business Continuity effort & managed all sub projects through their entire life cycle.
  • Performs systems analysis, systems architecture & design and assistance to EPM Data warehouse using Datastage on AIX platform.
  • Duties included to lead team delivering design, data mapping/cleansing, security/, implementation, and execution of all compliance and audit efforts for the State (financial, operational, and statutory).
  • Gather requirements from functional analysts and business users, analyze requirements, write business process diagrams, technical design and mapping documents.
  • Planned and coordinated system upgrades, releases and emergency system changes, Integrated AD data into Datastage for security.
  • Prepare specifications for data loading, design sequence templates, load, map and migrate data.
  • Develop and execute unit test strategies, configure and integrate software modules, design user interfaces establish connectivity, develop distributed computing, multi-platform client/server systems
  • Setting up Pre-ETL Framework for new feeds onboarding & DQ Framework for validations checks on feeds. Dealing with issues related to it & coordinating with various teams
  • Developing ETL Jobs using DS Tool, Data analysis, Performing Validation Checks.
  • Ownership of OBIEE components migration using Catalog Manager.

Confidential - OAKS

Environment: Datastage Parallel/Server 7.5/8.5, Exadata, Cognos 10.1.1/8.X, ORACLE 10g EPM 8.9 / EPM 9.1, HRMS 9.0, FSCM 8.9

Solution Architect/ Senior Datastage Developer

Responsibilities:

  • Provided expert technical systems advice & guidance to information technology managers (e.g., FIN functional & tech teams, HCM functional & tech teams, data security team, technical architecture team, PS admin/database) regarding all facets of project operations in support of Enterprise Performance Management (EPM) Data Warehouse.
  • Managed Planning, Plans implementation, & Projects tracking.
  • Model/design and code Extract Transformation & Loading (ETL) development & work with ORACLE database & DB2 database, to establish & maintain the EPM infrastructure.
  • Analyzed & designed components including Peoplecode/App Engine/SQR's of Government agency HCM running on Confidential application.
  • Conducted discussions with customers to review current & gather additional business requirements.
  • Responsible for establishing control and testing environments in order to enable the State to successfully fulfill its attestation, audit, and statutory compliance requirements on ongoing basis.
  • Analyzed & wrote business requirements, scope documents, program specifications & system documentation.
  • Performed systems analysis, systems architecture & design and assistance to data warehouse & Cognos report developers.
  • Maintained system design standards & procedures, analyzed system problems & created System Investigation Requests (SIRs) & Customer Relations Management (CRM) cases.
  • Integrated AD data into Datastage for security.
  • Supported and worked for Agency Adoption and Migration.
  • Created numerous dashboards/reports in OBIEE
  • Tuning the AIX ETL’s for better performance and Daily Batch completion.
  • Designed test procedures & tests system for validity & reliability, ensured logical & systematic conversion of customer requirements into total systems solutions that acknowledge scope, schedule & cost constraints.
  • Provided data analysis, data architecture & design assistance to functional/systems analysts, application developers & users.
  • Created logical & physical data models & data dictionaries, written system requirements, general & detailed design documents. Participated in management short & long term planning & assisted in agency wide policy & program development as it impacts automated systems.
  • Reviewed specifications, materials, tools, techniques & methodologies, act as technical liaison with software vendors, trained programmer/analysts in work functions & standards.
  • Created & maintained Enterprise Data Warehouse architecture and guidelines.

Confidential, Sunnyvale, CA

Environment: Datastage EE 8.0, OBIEE 10g, ORACLE 9i, AIX

ETL Architect/ Senior Datastage Developer

Responsibilities:

  • Managed the implementations through its entire life cycle from Discovery, Planning, Gap/fit Analysis, Design, Build, test and implement.
  • Led technical and functional teams and key decision makers developing and shaping technical standards, guidelines, IT roadmaps, usability and scalability.
  • Responsible for all technical deliverables.
  • Managed resources and workload of U.S. and offshore development and support team.
  • Gathering requirements from Functional Analysts and Business Users.
  • Writing Technical Design and Mapping documents for different SKUs of various marts.
  • Collecting, analyzing requirements and created TMD (Technical Mapping Documents) which require the dimensional modeling methodology.
  • Understanding a source system data and preparing a Technical specification for Data loading frequency, Format check, Granularity, Priority and Dependency.
  • Designing Individual job and sequence templates to load data to EPM data warehouse.
  • Integrated AD data into Datastage for security.
  • Involved as primary Datastage on-site technical lead during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software
  • Designed, coded, tested, and documented complete customized EPM application solutions.
  • Involved in all aspects of the product development lifecycle such as business requirements, functional specifications, architectural specifications, development, test plans, and documentation).
  • Used majority of stages like Join stage, Lookup stage, Merge, Transformer etc.
  • Develop efficient data model comprising of conceptual, logical and physical database design.
  • Develop Program Specifications, Unit and Module Test Plans.

Confidential, North Wales, AA

Environment: Datastage EE 8.0/7.5OBIEE 10g,Webmethods, ORACLE 9i, Linux red hat

ETL Architect/ Senior Datastage Developer.

Responsibilities:

  • Gathering requirements from Functional Analysts and Business Users to rationalize with vanilla version of EPM.
  • Connecting the DOTS between EPM HR data with EPM Finance Data for Confidential BI reporting.
  • Managed projects through their entire life cycle: initiation, planning, plans implementation to closing & delivery
  • Writing Technical Design and Mapping documents for different SKUs of various marts.
  • Collecting, analyzing requirements and created TDD (Technical Design Documents) which require the dimensional modeling methodology.
  • Understanding a source system data and preparing a Technical specification for Data loading frequency, Format check, Granularity, Priority and Dependency.
  • Designing Individual job and sequence templates to load data to Confidential EPM and documenting the templates.
  • Generating Dimension and Facts jobs from staging area and loading into Enterprise warehouse.
  • Used Datastage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
  • Design and Implement Data Model for target Data mart. Implement referential integrity between different areas of Business processes
  • Used majority of stages like Join stage, Lookup stage, Merge, Transformer etc.
  • Vast experience on Confidential EPM implementation, following Confidential conventions in creating ETL drafts.
  • Integrated AD data into Datastage for security.
  • Developing templates to extract trust asset data from source and load data to OWS, OWE.
  • Implemented Ralph Kimball methodologies to have conformed visibility.
  • Performance tunning of datastage jobs.
  • Worked with DataStage Administrator to create/modify/delete projects and cleanup projects
  • Update the management on issue and resolve.
  • Monitored and reported on service levels and incident management processes

Confidential, Redwood Shores, CA

Environment: Datastage 7.5, OBIEE 10g, ORACLE 9i, SQL Sever 2000, DB2/OS390 DB2/AS400, OpenText Experience Suite - Vignette StoryserverPeoplecode, Peopletools8.48

ETL Architect/ Senior Datastage Developer

Responsibilities:

  • Participated in requirements gathering of the various work streams by meeting with the business analyst and base lining the details to identify appropriate measures and dimensions.
  • Collecting, analyzing requirements and created TDD (Technical Design Documents) which require the dimensional modeling methodology.
  • Actively participated in team meetings and business meetings to understand the Business requirements.
  • Collaborated with project managers in the design, testing, and implementation of protocols and procedures
  • Worked closely with application portfolio managers to establish business need and prioritize work for development and implementation.
  • Established and coordinated support teams utilizing a global support structure.
  • Created source-target mapping spreadsheet using MS Excel to facilitate better understanding of the mapping and transformations.
  • Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.
  • Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
  • Implemented local containers for the same job and shared containers for multiple jobs that have the same business logic.
  • Used the expression editor to perform derivations and transformations using DSRoutines and DSTransforms.
  • Used DataStage Director to schedule running the server jobs, monitoring scheduling and validating its components.
  • Parameterized DataStage jobs to allow portability and flexibility during runtime.
  • Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel / Oracle Business Intelligence (OBIEE) Analytics platform.
  • Integrated AD data into Datastage for security.
  • Performed the detailed design of Analytical Data Model (Metadata / .rpd) and Reports / Dashboards.
  • Worked extensively in multi-user development environment on RPD.
  • Configured Repository, Session variables to generate dynamic reports
  • Training and mentoring new team members on process and tools.
  • Update the management on issue and resolve.

Confidential, Redwood Shores, CA

Environment: Datastage-7.5, Siebel Analytics 7.8, OpenText Experience Suite

Senior Applications Engineer/ Senior Datastage Developer

Responsibilities:

  • Analyzing the Various Design Scopes for the Campus Solutions and also understanding the Business Process pertaining to it.
  • Self learning included acquiring the functional knowledge of the Confidential Campus Solutions 8.9 source system.
  • Translation of business requirements into data mart design and developed ETL logic based on the requirements using DataStage 7.5.1.
  • Designed DataStage jobs to populate and incrementally load the source data to the staging area, created the update strategy, transformations, filters, lookups and necessary source-to-target data mappings to load the target using the DataStage Designer.
  • Involved in performance tuning of the ETL process and performed the data warehouse testing.
  • Created job sequences to handle the load dependency.
  • Developed parallel jobs using various stages like Transformer, Sort, Funnel, Data set, Sequential file, Oracle Enterprise Stages.
  • Used shared containers to reuse the specific business logic in various jobs.
  • Worked with various stages like the Aggregator stage, Pivot stage and Sort stage.
  • Used Datastage Manager to import the metadata definitions into various jobs.
  • Worked on the clean up, fixes and loading of metadata into the Warehouse.
  • Tasks also included backup of the ETL code line and delivery of the code line to the Client periodically.
  • Integrated AD data into Datastage for security.
  • Created customized reports from the existing Subjects Areas & incorporated Global Prompts & Filters.
  • Created Proactive Alerts /iBots using Siebel Delivers & delivered using Scheduler services.
  • Worked for the migration of Repository & Web Catalogs from Development to Test server.
  • Certified the jobs for AIX/DB2 compliance.
  • Design and developed various Dashboards /Reports that are Dynamic & Interactive with drill-down & drill-across capabilities with local & global filters.
  • Used SQL Developer to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.
  • Designed and Deploy Data Integration and Data Migration framework projects.
  • Created and maintained ETL design document and integration test plans.

Confidential, Pleasanton, CA

Environment: Datastage-7.1, Informatica, Business Objects, Windows NT

Analytics Developer

Responsibilities:

  • Planning and executing an extract, transform and load process and ensure successful execution by working with the QA team.
  • Understanding and analyzing the difference in the source structure of the earlier releases with the latest release (i.e. EPM 8.9).
  • Involved in documentation containing an explanation of various incompatibilities and fit gap analysis. Writing mapping documents from source to target data flow.
  • Develop and implement standard ETL processes in line with Enterprise standards.
  • Member of FST.
  • Created Master Sequencers to move data in a single run.
  • Certified the jobs for AIX/DB2 compliance.
  • Involved in laying out Oracle 9i database tables and database schema design
  • Involved in Upgrade Projects of EPM 8.9.
  • Fixed Issues related to FAT (Functional Acceptance Test) and Platform Test
  • Integration Update for Confidential Sources.

Confidential, Pleasanton, CA

Environment: Datastage-7.1, ORACLE 9i, Windows NT, People tools.

Analytics Developer.

Responsibilities:

  • Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing HR,SCM.FMS data warehouse data marts.
  • Involved in identifying the data inputs from various source systems depending upon the business requirement.
  • Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.
  • Designed and maintained logical and physical enterprise data warehouse schemas.
  • Created and documented various Data Quality Scripts to perform system integrated testing and user acceptance testing.
  • Development of staging jobs, dimensions, facts, utilities using DataStage tool.
  • Unit Testing, Regression testing.
  • Certified the jobs for AIX/DB2 compliance.
  • Lineage and Usage Documentation.
  • Created job sequences to handle the load dependency.
  • Used DataStage Manager for managing datastage repository (view and edit), define custom routines & transforms, Import and export items between different datastage systems.
  • Extensively used Business Objects to enable users to run-predefined sales and inventory reports for building their own customized reports.
  • Developed & maintained BO Universe Metadata.
  • Created END USER LAYER(EUL) for EPM8.9
  • Reports are generated using Discoverer Client Tool.
  • Reviewed codes, input to team on best practices.

We'd love your feedback!