SUMMARY:

• A result orientated professional with 8.5+ years of rich experience in design & development of Data ware house application encompassing client - server environment & multiple ETL & BI tools.Extensively used ETL methodologies in data extraction, transformations, and loading processing, in a corporate- wide-ETL Solution using Ab Initio 3.2 & 2.1 /Informatica Power center 6.2/6.1/5.1.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling’s like Star Schema and Snowflake
• Schema, SCDs (Type 1/Type 2/ Type 3), CDC loads.
• Involved in the implementation of Business Intelligence Applications using SSRS/Tableau, building Data Martsand enterprise-wide Data Warehousing.
• Hands on experience with Ab Initio components such as Join, Normalizer Rollup, Scan, Reformat, Partitioning & De-partitioning Component, Dedup sorted etc.
• Experience on PDL, metaprogramming , generic graph implementation , advanced Abinitio components, PSETS , plans , task , vector & vector manipulations having exposure & good understanding on different Abinitio products like Control Center, Express-it, Control Center, Conduct>it
• Strong understanding of the Citigroup bank-specific internal process and tools like Jira, Service Now, HPQC, Confidential Marketplace Resolve it.
• With Good Leadership skill & Communication skill efficiently managing an onshore and offshore team
• Familiar with Big Data technologies like Hadoop, Spark.

TECHNICAL TOOL SKILLS

ETL Tools: Ab-Initio (GDE- 1.14.27/Co-op 2-14-1) & (GDE - 3.2.7 Co-Op V3-1-5), Informatica Power center 6.2/6.1/5.1.

BI Tools: Tableau 10.5, SSRS 2016

Database: Oracle 10G,11G / SQL Server 2016/2018, Netezza 6.02, MEMSQL, DB2

Script/Language: Python, Shell script, SQL

Business Domains: Banking Insurance, Manufacturing, Entertainment, e-commerce

Application: Service Now, Jira, HPQC, Resolve IT, IFW, Confluence page

Scheduler: Control Center, Report builder & Report Manager

Big Data Tech: Hadoop, Spark, Hive

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Data Specialist

Responsibilities:

• Ensure Best Practices are followed for reducing redundancy of code and major focus on improving Performance and reusability of artifacts across the projects. Responsible for effective communication between the Business User & developer.
• Establish Quality Procedure for the team and continuously monitor/mentor to ensure team meets quality goals.
• Developing & Deploying Data warehousing solutions for new implementations and upgrades for clients for ETL (Extraction, Transformation and Loading) and Business Reporting area.
• Sets deadlines, assigns responsibilities, mentors, and monitors progress of the team.
• Identifying issue in production & Ensuring team made the required communication to all the impacted user & consumer.
• Provide analysis details for the Production problems encountered. Ensure the Production problems are resolved within SLA
• Managing audit and data privacy standards requirement within the project team are established.

Confidential

Application Support Analyst

Responsibilities:

• Provide technical expertise in both development and production to increase the performance of batch.
• Working on various TSP and prepared KT Document for Team and making sure entire team is up to speed for any issue.
• Worked in highly parallelized (MPP Solution) Ab initio environment to process 1+Tera bytes of data daily.
• Worked with Infrastructure team to write some custom shell scripts to serve the daily needs like collecting logs and cleaning up data.
• Extensive usage of Multi-file system where data is partitioned into four Partitions for parallel processing.
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
• Deployed and test run graphs as executable k-shell scripts in the application system.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs.

Environment: Abinitio GDE 3.1, IFW, UNIX, Netezza 6.0.2, Oracle 11 g, PL/SQL.

Confidential

Senior Software developer

Responsibilities:

• Work with Business Analyst in translating business requirements into Functional Requirements Loading the data from Source to Staging1 and Staging2 to Target (DWH) according to the Business requirements
• Worked extensively on SQL Server database and flat files as data sources.
• Developing New Graph for removing fraud record, automate deleting & loading data country wise and editing old graph as per requirement.
• Data validation task, stored procedure & Troubleshooting for data issues.
• Developing, Supporting and troubleshooting all issues with international TV Ratings.
• Developed graphs to unload data into tables and validate the new data in.
• For Error Handling by attaching error and rejecting files to each transformation and making provision for capturing and analyzing the message and data separately.

Environment: AB Initio (1.14/2.14), tableau, MS SQL server 2008

Confidential

Senior Software developer

Responsibilities:

• Developing new report as per the requirement, also making changes in existing report
• Deployed the generated reports directly on the client’s workstation using report manager
• Using report builder Maintain the report model for new table & new changes.
• Making all the changed object into stage ready format once run successfully on Warehouse-2 deploy on to main staging area & Deployment of application in stage mode.
• Documentation of the application for app server point of view.
• Provide technical expertise in both development and production
• Development of packages for loading data from ODS to TDS using Different Database component like input table, output table look up, truncate table.

Environment: Microsoft Business Intelligence (SSRS) MS SQL Server 2008, delimited file