SUMMARY

• 8 years of Information Technology experience in Datastage 8.5,11.3&11.5 Technology on administration, Production support, design, development, and implementations of robust technology systems, with specialized expertise in Data Warehousing solutions. Able to understand business and technical requirements quickly; Excellent communications skills and work ethics; Able to work independently; Experience working with clients of all sizes in the healthcare, Insurance, Banking, Financial, Retail and manufacturing industries.
• Worked as Technical Analyst and Senior Software Engineer of business requirements, Design and Development of ETL Applications, Architecture of Data warehouse, Documenting DLD’s Mock data and Test cases.
• Strong experience in data modelling to translate business rules/requirements into conceptual/logical dimensional model and worked with complex deformalized and normalized data models
• Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema)
• Expert in Data Warehousing techniques for Data Cleansing
• Extensive experience in DataStage (ETL) and Data modeler. Technical knowledge using DataStage designer and Director, Developing Ds jobs, Uint testing and production Support.
• Analysis on Business requirements
• Discussion with BBIA (Bank Business Intelligence Administration) Team and Business Partners on
• Business Requirements
• Analysis on business developed and supported UDA’s (User Defined Applications) under each work stream in its current state
• Analysis and Documentation of Trusted Data Sources
• Agile: Modeling in Strategic Foundation and Information Data Layers
• Development of ETL Components for Data Enrichment in Foundation data layer thatBODDH- Bank Operation Data Distribution HubHadoop- Big Data Strategic Data Infrastructure
• Development of ETL Components for Data Enrichment in Information Data Layers that Include:GPM- Bank General Purpose Data MartSAM- Bank Subject Area Data Mart
• Engage in Data Validation with BBIA SME and receive approval for implementation of developed infrastructure components.
• Deployment and Maintenance of developed Data Infrastructure ETL and DB Components
• Development/Enhancement of Tableau Reports that facilitate for exposure of Data from Strategic
• Data Infrastructure layers
• Work with BBIA partners to enable them in accessing Strategic Data Infrastructure layers and thereby eliminate need for maintenance of the UDA’s.
• Documentation Delivery (Wiki and other project documentation)
• Work on enhancement projects and monitor all data stage jobs and provide production support
• Lead and coordinate the work of an offshore data integration development team in India, including daily offshore sync calls with that team
• Create and maintain adequate project and support documentation
• Periodically review and enhance design and development standards and practices as needed in collaboration with ETL team
• Strong understanding of data warehousing concepts, Schemas, Slowly Changing Dimensions,
• Facts and Dimensions, and implementation of the same.
• Develop and support Control M scripts and jobs to support projects and DW loads
• Ability to balance multiple projects and work both independently and as part of a team
• Facilitates root cause analysis of system issues to minimize impact and future occurrences
• Migration from Data Mart On-Site Premises to cloud-based Data Marts (Snowflake Cloud
• Computing)

TECHNICAL SKILLS

Languages: Java, python, C, C++, XML, PL/SQL, HTML.

File Systems: Main Frame Files, CSV, CFF

RDBMS: Oracle, DB2, SQL Server, Teradata, Netezza.

ETL Technologies: DataStage 8.5,11.3,11.5

Operating Systems: Ms-Dos, Microsoft Windows 98/2000/XP,MS XL, Unix

Data modeling: Erwin (CA), Data modeler

BI & Reporting Tools: Tableau, Qlik View, Qlik Sense

RPA Tools: Automation Anywhere

Other tools: Toad, Azure, SQL Developer, Putty, WINSCP, Service now, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Sr. Datastage Developer

Responsibilities:

• Analysis on Business Requirements.
• Discussion with BBIA and Business Partners on Business Requirements.
• Analysis on business developed and supported UDA s (User Defined Applications) under each work stream in its current state.
• Analysis and Documentation of Trusted Data Sources.
• Agile: Modeling in Strategic Foundation and Information Data Layers.
• Development of ETL Components for Data Enrichment in Foundation Data Layer that include

Technologies/Platform Used: ETL DataStage, Netezza, UNIX, SAS, Tableau, Control M and Jira Agile Tool.

Confidential

Sr. ETL/ DataStage Developer

Responsibilities:

• Analyzing and understanding business requirements.
• Developing design documents for each project Specific.
• Deploying and testing the project into various UNIX test regions.
• Working on the production issues.
• Design and development of ETL Applications.
• Developed test cases to test the developed rules.
• Understanding and writing the Performance testing scenario documents.
• Independent Unit Testing of the DataStage processes.
• Estimation and effort tracking to aid the management of the application.
• Data analysis to provide insights to business for further decision making.
• Involved in Design/Code reviews.
• Preparing unit test cases and mock data.
• Working on bot inbound and outbound process.
• Created and implemented ER models and dimensional models (star schemas)
• Generated SQL scripts
• Assisted DBA’s in the development of physical database
• Assisted Data modeler Architect’s in the development of physical database and understanding the logical database.
• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Developed a Conceptual model using Erwin and Visio based on requirements analysis.
• Responsible for designing the data Architecture, designing Conceptual, logical and Physical data models and maintaining the data Dictionary as for the Standards.
• Designed Source to Target mapping document with transformation rules, physical naming standards, datatypes and domain definitions for ETL team.
• Code and test highly complex ETL processing the support of data warehouses and/ or operational data stores.
• Determine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
• Work closely with project management, analysts, data modelers and the existing ETL design and developers to understand project requirements and contribute to the project solution.
• Provide technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration
• Partner with Business Intelligence and business operational teams to understand data sources and implement new requirements.
• Analyze and summarize data to facilitate Business Intelligent decisions.
• Supporting the system and integration testing to ensure the correct functionality of the system and its interfaces with various test scenarios and review of Test Cases and Test Results.
• Identify, track defects and analyze root cause of defects and provide maintenance and enhancement support for the deliverables that are being done.
• Coordinating with Business Analysts and users to understand the new proposals and their impact on the existing systems if any.
• Evaluate business requirements, perform gap analysis and identify the design alternatives and finalize the approach for the implementation.
• Analyzing the existing system if any to find out the reusable components, dependencies and document the same

Tools: & Technology: DataStage 11.5, Teradata, UNIX, Control-M, CA Erwin Data Modeler, RTC, WInSCP, Servicenow

Confidential

Sr. ETL/ DataStage Developer

Responsibilities:

• Gathering and analyzing business requirements.
• Developed the DataStage jobs using DataStage designer.
• Design and development of ETL Applications.
• Independent Unit Testing of the DataStage processes.
• Estimation and effort tracking to aid the management of the application.
• Data analysis to provide insights to business for further decision making.
• Involved in Design/Code reviews.
• Performed the design and code reviews.
• Determine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
• Work closely with project management, analysts, data modelers and the existing ETL design and developers to understand project requirements and contribute to the project solution.
• Provide technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration
• Partner with Business Intelligence and business operational teams to understand data sources and implement new requirements.
• Analyze and summarize data to facilitate Business Intelligent decisions.
• Worked with DataStage manager for importing the metadata for database source.
• Design and review of the DataStage Jobs and routines which are created sequential files sourcesandtargets.
• Designed, developed and deployed DataStage jobs using various stages like Join, Transformer, Lookup, Aggregator, Funnel, Modify, Filter, Change Data Capture, Change Apply, Remove Duplicate, Sort, Surrogate Key stages etc.
• Supporting the system and integration testing to ensure the correct functionality of the system and its interfaces with various test scenarios and review of Test Cases and Test Results.
• Identify, track defects and analyze root cause of defects and provide maintenance and enhancement support for the deliverables that are being done.
• Preparation of implementation plan and all the relevant supporting documents.
• Migration of jobs from Development to QA and to Production Environments.

Tools: & Technology: DataStage 11.3, DB2, Oracle, UNIX, Autosys, Flat files, CA Erwin Data Modeler, RTC, WInSCP, Servicenow, JCL, Mainframe Files

Confidential, Parsippany, NJ

ETL/ DataStage Developer

Responsibilities:

• Providing support to L2 team, Handling the new requirements and code fixes
• Understanding the Functional Specifications.
• Analyze Mapping Documents and Design Specifications.
• Coordinating with the client to ensure product compliance
• Developing solutions for Complex Problems using the stages like Lookup, Join, Transformer, Sort, Aggregator, Sequential file, funnel and filter for developing jobs
• Understands the Complex processes and implemented the logic in DataStage jobs
• Created Extract and Load jobs for transforming and loading the data.
• Designed the jobs according to the business requirements.
• Involved in keeping track of Error Handling for rejected records
• Involved in Unit Testing, Integration Testing
• Understanding and writing the Performance testing scenario documents.
• Independent Unit Testing of the DataStage processes.
• Estimation and effort tracking to aid the management of the application.
• Data analysis to provide insights to business for further decision making.
• Involved in Design/Code reviews.
• Preparing unit test cases and mock data.
• Working on bot inbound and outbound process.
• Created and implemented ER models and dimensional models (star schemas) Generated SQL scripts
• Supporting the system and integration testing to ensure the correct functionality of the system and its interfaces with various test scenarios and review of Test Cases and Test Results.
• Identify, track defects and analyze root cause of defects and provide maintenance and enhancement support for the deliverables that are being done.
• Designed, developed and deployed DataStage jobs using various stages like Join, Transformer, Lookup, Aggregator, Funnel, Modify, Filter, Change Data Capture, Change Apply, Remove Duplicate, Sort, Surrogate Key stages etc.
• Preparation of implementation plan and all the relevant supporting documents.
• Migration of jobs from Development to QA and to Production Environments.

Tools: & Technology: DataStage 8.5, Oracle, SQL Server, Flatfiles, CA Erwin Data Modeler, RTC, WInSCP, Servicenow