SUMMARY:

• Having 11 years of Software professional experience in Data Warehousing and Business Intelligence(DW&BI) as a ETL Developer, Data Analyst, End to End Designer, Team lead, Technical lead and Project Lead in multiple projects across geographies.
• Well versed in various phases of SDLC that includes Requirements Gathering, Analysis, Design, Development, Testing, Implementation, Production Code Support and Maintenance for end - to-end IT solution offerings.
• Good knowledge in Data warehousing concepts, Informatica ETL, Teradata, Oracle SQL, Data science, Machine learning using R programming, Python, Big Data, Qlik view and Talend Data Integration.
• Experienced as Database SQL Developer in Teradata, Oracle 9i and SQL server to Recover the data, Performance Tuning, Table Partitioning, Database Architecture, Monitoring, and Database Migration.
• Solid skills in data analysis, data profiling, data compiling, data transformation mappings and data validations.
• Skilled to Develop, Test, Tune and Debug the Informatica Mappings, Sessions and Monitor the system.
• Experienced in conceptual, logical and physical data modeling for OLTP, OLAP and Enterprise Data Warehouses and Data Marts.
• Pioneered in different load strategies from heterogeneous sources to target. Successfully implemented SCD Type1/Type2 load, Capture Data Changes to maintain the Data history.
• Excellent to write the Stored Procedures, Triggers, Indexes, Functions by PL/SQL, SQL Scripts and BTEQ scripts. Developed various reports, dash board using Actuate reporting tool and Tube maps using Qlik View.
• Proficient in Designing the Automation Process of Workflows and configuring/scheduling the Workflows/jobs for load frequencies.
• Experienced to identify the Bottlenecks of data load and Tuned the Bottlenecks for better performance.
• Experienced in Release management and Migration of codes from Repository to Repository, prepared Technical/Functional Specification Documents along with unit test and validation documents.
• Experienced in designing Data Acquisition processes that involves multiple legacy and contemporary System/Source of Records.
• Good Domain Knowledge in Banking and financial services - Mortgage Banking, Retail banking, Card services and Insurance.
• Strong technical, managerial, leadership and interpersonal skills.
• International work experience, working face to face for clients in USA, India and UK at client locations. Skilled to interact with business users and various stakeholders.
• Excellent problem solving, communication skills with ability to clearly explain complex technical aspects into easily understandable concepts.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, Informatica Data Quality (IDQ), Talend Data Integration

Database: Oracle, SQL-Server, Teradata

Reporting Tools: Cognos, Actuate, Qlik View

GUI Tools: Teradata SQL Assistant, Queryman, BTEQ, TOAD, SQL Plus, Putty, WinSCP, R-Studio, Anaconda.

Languages: SQL, PL/SQL, Python, R- programming, C, C++, VHDL, Verilog.

Operating Systems: Windows 93/95/98/ME/NT/XP/ 7/8, Vista, Unix, Mac.

Scheduling Tools: Tivoli, Control-M.

PROFESSIONAL EXPERIENCE:

Confidential

ETL designer, Data Analyst, ETL & BI developer and Project lead

Responsibilities:

• Performed an extensive data analysis on the current data movement process and procedures in databases.
• Performed the impact analysis for tokenizing sensitive data and SRP changes on the existing applications.
• Prepared the requirements traceability matrix documents capturing the functional and non-functional requirements.
• Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the Application.
• Conducted Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) model versus the Target (TO BE) model.
• Presented the strategic and tactical solution approaches to the project teams to easily decide the best approach to follow under the stringent project timelines.
• Prepared the High level design documents with clearly capturing the design constraints, risks, assumptions, dependencies and issues.
• Selected the appropriate elicitation technique to efficiently identify critical requirements and High level designs by conducting multiple walkthrough sessions with the various stakeholders, Design Authorities, vendor and CIO’s for review and sign off’s.
• Supervised the data warehousing functions of data compilation, extraction, loading, cleansing and modeling.
• Additional responsibilities include ensuring the tokenization design for card data is PCI-DSS compliance and align to the GIS (Global Information Security) administration functions.
• Built the Telephony data model for mortgage calls to improve the automated machine call answering process for better business needs.
• Data exploration and transformation, created Teradata BTEQ scripts and store procedures to load the Call data model on daily and monthly basis.
• Project management experience includes day to day interaction with client to report progress on existing projects and discuss the feasibility of new projects, business impact analysis/risk analysis, prepare status & metric reports and manage & train junior associates on the team.
• Created a tube map view using Qlik View, projecting the daily/weekly/monthly/quarterly call volumes and call journeys through the mortgages- telephony waterfall model.
• Development of Teradata SQL procedures to in corporate complex business logic and load the daily Call data into the telephony data model.
• Created weekly reports, provided statistics and graphs to the business users.
• Project Plan Preparation, scheduling all project activities and conducting weekly Status Conference with the Client Project Management team.

Environment: - Informatica PowerCenter, Teradata, SQL, PL/SQL, Putty, WinSCP, UNIX ShellScripting, TWS (Tivoli workflow Scheduler)Big-Data, Hadoop Data lake, Protegrity Tokenisation- FPG, AP and ESA appliances.

Confidential, Texas

Technical lead.

Responsibilities:

• Lead the Cognizant Confidential (DIH) team for building a centralized source of truth across the NationStar enterprise for all reporting needs in Mortgage banking.
• Performed business impact analysis & feasibility analysis of proposed project, processes and provide solutions.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers and data analysts, peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.
• Conducted business risk analysis to identify and develop effective risk mitigation strategies.
• Review and revise project plans to meet challenging requirements on the project.
• Interacted with business users to gather and document requirement specifications.
• Extensively worked on data analysis, data profiling, data cleansing and data validation processes to ensure no gaps in data and maintain data integrity.
• Involved in architectural analysis, risk assessment, design, development and testing activities of the project.
• Created store procedures & queries for the complex business logic to accomplish the business reporting needs.
• Additional initiative undertaken in conducting knowledge sharing sessions amongst the team for quality deliverables and to have better understanding on mortgage banking terminology to the new entrants.
• Peer-reviewed the code to cross-check if the logics are accurate or not to meet the business requirements and client standardization based on Tech Specs, fixed them if there are any discrepancies.
• Identify the feasible alternative approaches, systems and equipment reduce cost, improve efficiency while meeting the expectations.
• Coordinate multiple DIH Mortgage Banking releases throughout the year which requires tracking the development status, review, release management and deployment of code.
• Mentored individual team members for improved performance, manage personal development plans for all direct reports and define a clear career path.
• Project Plan Preparation, scheduling all project activities and weekly status conference with the Client Project Management teams.
• Communication and deliverables between Cognizant onsite-offshore and work with the client teams.
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.

Environment: - SQL Server 2008, SSIS, SSRS, Cognos, PL/SQL, SQL Plus, Putty, UNIX Shell Scripting, SQL-Developer.

Confidential, Texas

ETL Team lead.

Responsibilities:

• Designed and developed Jobs by Unix Scripts for Control-M to schedule workflows. Created Pre-& Post-Sessions UNIX Scripts, SQL Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on data.
• Guided the other developers and provided the technical solutions in need, peer reviewed their codes to meet the accurate business requirements and project standardization.
• Conducted daily/weekly meetings, monitored the work progresses of teams and proposed ETL strategies.
• Coordinate multiple Confidential Mortgage Banking releases throughout the year for ETL team with requires tracking the development status, test cycle executions, review, release management and deployment of code.
• Involvement in imparting domain and technical knowledge to the new entrants and also fellow team members.

Environment: - Informatica PowerCenter 9.1, Teradata 13, SQL, PL/SQL, SQL Assistant, Putty, WinSCP, UNIX Shell Scripting, SQL-Developer, JIRA, Control-M, SVM.

Confidential, Texas

Development and Production Support Team lead

Responsibilities:

• Performed Project Requirement Analysis, System Study and Estimation.
• Guide and supervise ten onsite and off-shore resources.
• Requirement gathering for all new development and enhancement projects.
• Automation of existing manual jobs and processes reducing manual efforts.
• Continuous tracking of production issues and provide solutions to prevent recurring issues.
• Coordination between client business leads and Cognizant development team to ensure quality services.
• Continuous performance tuning of production jobs providing improvement in the completion times for critical production jobs.
• Project Plan Preparation and Scheduling all enhancement and development activities
• Prepare the Proof-Of-Concepts (POC) at the client environment and pass them to the developers and the implementation of those in the respective client environments.
• Communicate deliverables between Cognizant onsite-offshore and work with the clients.
• Provide reports on open/closed request segregated based on severity/priority levels and Analysis of the internal systems used at JPMC.
• Guide team members in all technical challenges faced in the execution of project
• Knowledge Management to create repository of system/business/domain knowledge
• Involvement in implementation of the code changes to the Confidential source system programs and jobs.
• Reverse engineer the existing ETL code to identify the transformation/business logic.
• Effort and Schedule Tracking, Metrics Collection, Analysis and Reporting.
• Responsible to ensure 24*7 production support for the project.
• Provide statistical reports to business on various metrics like SLA misses during the month, number for production issues faced during the month etc.
• Induction of new resources to team and knowledge transition
• Knowledge Management to create repository of system/business/domain knowledge
• Weekly Status Conference with the Client Project Management
• Internal/External Quality Audit Representative of Project.
• Ensure adherence to Cognizant/JPMC Standards in Release/Change Management.
• Primary escalation point for all issues in JPMC Default MIS Confidential project.

Environment: - Informatica(8x,9x), Oracle SQLPlus, PL/SQL, SQL developer, TOAD, Unix, WINSCP, PUTTY, Microsoft SQL Server, Cognos, Control M scheduler.

Confidential

Senior Application Developer

Responsibilities:

• Prepared ETL technical Mapping documents along with test cases for each Mapping for future developments to maintain SDLC
• Created reusable components like user defined functions, mapplets, store procedures etc.
• Wrote various Functions, Triggers and Stored Procedures to drop, re-create the indexes and to solve the complex calculations
• Coordinating with the onsite team daily to capture the requirements changes in the ETL code.
• Producing bug free codes and error free documents and contributing in delivering products well within schedule.

Environment: - Informatica PowerCenter 8.6, Informatica Data Quality (IDQ), Rapid SQL7.2.1, SQL, PL/SQL, My SQL, Putty, WinSCP, UNIX Shell Scripting, SQL-Developer, Python.

Confidential

Application Developer

Responsibilities:

• Participated in various stages of data and requirement analysis for project needs.
• Developed a prototype based on Teradata FSLDM architecture before the project start.
• Developed and tested mappings, workflows, BTEQ, Fastload, Fastexport and Multiload scripts, which handles delta logic as per the architecture.
• Preparation of the Proof-Of-Concepts (POC) at the client environment and pass them to the developers and the implementation of those in the respective client environments.
• Implementation of POC using pushdown optimization in Informatica for performance tuning
• Creating/modifying DDL (Data Definition Language), choosing UPI (Unique primary index), PPI (Partition primary index) and SI (Secondary Index)
• Implementation of the Error and Audit Model specifically designed for the EDW Integration projects under stringent time lines.
• Performed key data profiling steps that identified the mapping issues related to historical conversion needs for Hierarchy/GL trending reports.
• Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets and configured them according to business logics & requirements to load data from different Sources to Targets.
• Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings.
• Involved in developing a comprehensive system Test Plan and created the Test Cases.
• Created Pre & Post-Sessions UNIX Scripts to merge the flat files and to create, delete temporary files, change the file name to reflect the file generated date etc
• Ensure the code is in adherence to Cognizant/WaMu Standards.

Environment: - Teradata V2R6.2, Informatica 8.1, Teradata Utility tools (BTEQ, Fastload, Fastexport, Multiload and TPUMP), Putty, WinSCP, UNIX Shell Scripting, Teradata SQL Assistant.

Confidential

Application Developer

Responsibilities: -

• Responsible for Physical Implementation of Teradata system which includes converting Oracle DDL to Teradata DDL using Oracle’s data dictionary tables
• Participated in various stages of data and requirement analysis for project needs.
• Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets (command, email, assignment, control, event wait/raise, conditional flows etc) and configured them according to business logics & requirements to load data from different Sources to Targets.
• Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings.
• Involved in developing a comprehensive system Test Plan and created the Test Cases.
• Implemented a Bug free Informatica code to migrate data from Oracle to Teradata database.
• Analyzed and worked on the fastload scripts by considering performance factors into account to move data from ODS to staging area and staging area to target area respectively
• Created Pre & Post-Sessions UNIX Scripts to merge the flat files and to create, delete temporary files, change the file name to reflect the file generated date etc
• Prepared detailed Functional Specification/Design and Review documents.
• Wrote SQL queries to test the application for data integrity.
• Ensure the code is in adherence to Cognizant/WaMu Standards.

Environment: s: Informatica Power Center 7.2, Teradata V2R6.2, Oracle 10g, PL/SQL, Toad, Query Man, UNIX Shell Scripting, BTEQ.