SUMMARY

• 4 years of experience working on ETL Tools - IBM InfoSphere Datastage Server/ Parallel Edition (Version 7.5, 8.1,8.5 and 9.1) and SSIS SQL Server Data Tool.
• 2 years of experience on creating Data Traceability/validation and Data Lineage using ASG Becubic tool.
• Strong experience developing T-SQL queries/scripts and involved in performance tuning on SQL queries.
• 4 years of experience in ERP PeopleSoft EPM 9.1/ FSCM 9.2 and PeopleTool 8.51.
• Proficient in Relational Database Management Systems (RDBMS) concepts and NoSQL Database concepts.
• Experience on Database Modeling/Designing using ERwin to design Conceptual/Logical/Physical Modeling and Forward/Reverse engineering.
• Strong knowledge on Data Warehousing design/concepts; Data Warehouse architecture, Data modeling Techniques/concepts, Dimensional modeling (star schemas and snowflakes schema) Dimensional Modeling on OLTP and OLAP concepts using Ralph Kimball and Bill Inmon methodologies, Normalization/De-normalization techniques, OLTP/OLAP etc.
• Courses completed on Hadoop (HDFS) ; No-SQL database concepts; MongoDB and Cassandra database;
• Database Administration (DBA) level knowledge on Oracle 12c - Complete knowledge on Database architecture; Implementation, configuration, upgrade, troubleshooting and performance tuning. Strong knowledge on Oracle RMAN backups/restores and OEM interface.
• Database Administration level skills on Microsoft SQL Server 2014 - Create documentation and procedures for installation and maintenance; DBA tasks - Installation/upgrade, Failover cluster, Troubleshooting, High Availability, Performance, Maintenance, Security, Backup/Recovery.

TECHNICAL SKILLS

BI tools: Tableau; SSRS

RDBMS: DB2; Oracle 11g/12c; SQL server 2014/2016; MySQL, teradata

Database Admin: SQL Server 2014; Oracle 12c, RMAN, OEM

Data lineage: Tools/Utilities

SQL scripting: ERP PeopleSoft 9.1

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

SQL Developer

Responsibilities:

• Understanding the specifications for Data Warehouse and ETL Processes by interacting with the client and end users for gathering business requirements.
• Worked with the Team and organized meetings to help team regarding the Data Analysis.
• Created the Functional Specific documents on various retail and wholesale loan sources including Student Lending, Auto Loans, Corporate Loans
• Created the TSDs, technical specific documents for the Business specifications for all the ETL jobs.
• Gathered requirements and developed various ETL jobs, which generate meaningful financial data across multiple source systems..
• Responsible for all pre-ETL tasks upon which the Financial Data Warehouse depends, including managing and collection of various existing data sources.
• Expertise in creatingdatabases, users, tables, views, stored procedures, functions, Packages, joins and hash indexes in RDBMS database.
• Proficient in performance analysis, monitoring and SQL query tuning usingEXPLAIN PLAN,Collect Statistics, Hints and SQL Trace.
• Involved in Unit testing, System testing and debugging.

Confidential, Plano-TX

Responsibilities:

• ETL Developer - involved in creating ETL jobs; analyzing and scanning jobs, later creating lineage/tracebility
• Writing and rectifying complex SQL queries for performance tuning and generating reports.
• Daily involved in performing data analysis/data validation and generating reports for user
• Involved in creating data traceability/lineage report (After scanning, data has been further analyzed and processes).
• Involved in data/metadata scanning (collector software) - Becubic source collector extracts metadata information about the programs, transaction, files, jobs, scheduling information and database within a host environment.

Confidential, Plano-TX

ETL Developer

Responsibilities:

• ETL Developer - involved in creating ETL jobs in SSIS; ; analyzing and scanning jobs, later creating lineage/tracebility
• Writing and rectifying complex SQL queries for performance tuning and generating reports.
• Daily involved in performing data analysis/data validation and generating reports for user
• Involved in creating data traceability/lineage report (After scanning, data has been further analyzed and processes).
• Involved in data/metadata scanning (collector software) - Becubic source collector extracts metadata information about the programs, transaction, files, jobs, scheduling information and database within a host environment.

Confidential

Responsibilities:

• Involved in completeSoftware Development lifecycle(SDLC) of various projects,including Requirements gathering, System Designing, Data modeling,andETL design, code development, scheduling, testing, Production Enhancements, Supportand Maintenance using Data Stage Designer and Data Stage director.
• Leading daily project requirements and deliverables.
• Responsible to communicate with business users and project management to get business requirements and translate to technical specification for various purposes like data conversion/migration from legacy databases/utilities.
• Interpreting business requirements into technical requirement for further development.
• Working with diverse teams spread across Europe, HK, North America, Turkey, Asia pacific region for requirement gathering, implementation, validation etc.
• Creating conceptual and logical data models as a part of the functional and technical requirement (using Erwin).
• Prepared Analysis, Design and Technical specifications document and Test cases.
• Developing strategies for Extraction, Transformation and Loading (ETL)/Data conversion mechanism.
• Daily activity on writing complex SQL queries for database and ETL jobs along with performance tuning on SQL queries.
• Designing, writing complex SQL queries, documenting, testing of ETL jobs and mappings in Server/Parallel jobs to populate tables for Data Warehouse.
• Developed parallel jobs using various stages; coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Extensively worked on building datastage server/parallel jobs using various stages like Oracle Connector, Funnel, Transformer stage, Sequential file stage, Dataset, Look-Up, Join, Sort, Merge, Aggregator, Filter, Copy, etc.
• Import/Export repositories across projects.
• Involved in Production support - Extensively worked on North America regional specific ETL jobs addressing data issues, performance tuning, environment issues and enhancements.
• Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling (Star Schema modeling, and Snowflake modeling).
• Expert in Unit Testing, System Integration Testing, User Acceptance Testing, Performance Testing and Implementation.
• Involved in data migration activity using Oracle SQL Loader or PeopleSoft import/export utility.
• Designing PeopleSoft interfaces by creating Records, Pages, Components, and Menu etc. using Application Designer as per business requirement.
• Developed Excel to CI utility to Upload Domains into PeopleSoft system.
• Developed Application Engine to load trees from file to PeopleSoft system.
• Worked on PeopleCode for establishing business validations.
• Performing data validation on resources/cost allocation.
• Created various PeopleSoft Queries for finance users. Also, setup Jobsets for many regional sites.
• Used process scheduler to run scheduled processes and used Process Monitor to view status of the processes.
• ‘Migration Manager’ - Involved in activities like requirement analysis, technical design preparation, coding, testing and documentation; Responsible for code and data migration to production sites (including ETL packages) with the use of Quest STAT (Version Control Tool); Responsible for handling data Import/Export in production environment with millions of rows using SQL loader.
• Actively involved in ‘Production Support Team’ for various regional sites including Hong Kong/Mexico/Turkey/Dubai/ Seoul/China/Manila/North America/Canada using MKS Support Request; Also involved in upgrade activity and MI (Management Information) related tasks.
• Played role of ‘Defect Prevention Coordinator’ and took necessary actions for defect prevention. Also played role of SCM (Software Configuration Manager), which involves managing the documents like WSR, PSR, Issue Log and MOM to DOMDOC (Version Control Tool) Repository.
• Provide functional and technical training to team members