SUMMARY:

• 7 years of Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading and 6+ years of Data Warehousing testing experience.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Worked on Mainframe / Java Web services.
• Hands on Teradata load utilities like Fast load and Multi Load
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Experience in Data profiling and Data cleansing.
• Expertise on Loan IQ Trader Desktop and Loan IQ configuration, integration and reporting module.
• Expert in using native teradata tools like viewpoint, PMON and TD Manager.
• Expert in tuning and troubleshooting teradata system at various levels.
• Good experience in data analysis, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Good Knowledge on AWS and Python scripting.
• Hands on experience in Cloud engineering.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, T - SQL, Sybase, and Teradata, MS Access, GreenPlum, Flat files into a staging area.
• Experience in analysis, modeling, design, and development of Tableau reports and dashboards for analytics and reporting applications.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Good team player, experience working with diverse international teams. Self-starter and motivated individual can work under minimum supervision.

TECHNICAL SKILLS:

Databases: Oracle, MySQL, SQL Server, T-SQL IBM DB2, MS Excel, MS Access, Greenplum, Teradata, Netezza

ETL Tools: IBM Infosphere Datastage Informatica Power Center (8.1,8.5,8.6,9.1/ Power Mart), SSIS

Languages: RDBMS & HTML, T-SQL, PL/SQL, C/ C++, Python, Hadoop, Java, Visual C++, Visual Basic 6.0, HTML, XML

Design Methodologies: UML, OOP

Reporting Tools: Business Objects XIR13, Tableau, SQL Server Reporting Services, Excel Spread Sheets, Crystal Reports, Cognos

Application Packages: MS Office, MS VSS.

Quality Assurance/Methodologies: Agile, Waterfall, SCRUM, Test Plan, Test Strategy, Defect Tracking

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Analyst

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Extensive involved in Data Analysis, Data Cleansing, Requirements gathering, Data Mapping, Functional and Technical design docs, and Process Flow diagrams.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application and to check dataflow in different environments.
• Extensively used joins and sub Query’s and functions for validating data.
• Monitored the Teradata production system using Teradata manager for skewed queries.
• Conducted source-system data analysis to understand current state, data quality and availability of existing data.
• Expertise on Loan IQ Trader Desktop and Loan IQ configuration, integration and reporting module.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, DDL Commands and DML Commands (SQL) . Created various Teradata Macros in SQL Assistant for to serve the analysts
• Extensively worked on Data cleansing and Data staging of operational sources using ETL processes.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD.
• Worked extensively on UNIX environment .
• Monitor network and Mainframe/Tandem systems and other applications
• Write Complex SQL queries to reflect those rules and be able to validate the mappings by running these test scripts and checking if the data in target table populates correctly by writing complex SQL queries.
• Involved in SQL Optimizations, Performance Analysis, and future growth analysis for OLTP and data warehouse applications.
• Involved in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Collected requirements and tested several business reports.
• Perform Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).
• Performed Functional Testing and Backend Testing using the database comparable results manually.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Validated the data flow from centralized database to different products by executing SQL.
• Worked with Data masking validation between different schemas using Toad for oracle and SQL server.

Environment: Informatica Power center 9.6, Teradata, Oracle 11g, LoanIQ, TOAD, HP Quality Center, BusinessObjects Enterprise XI R2/ R3, Oracle SQL, PL/SQL, Windows, UNIX, Excel, MainFrames..

Data Analyst

Responsibilities:

• Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.
• Conducting BI applications and Database system study & coordinating with team members for system design, integration & application maintenance.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables using Informatica Power center 8.6.
• Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Designed and Optimized Data Connections, Data Extracts, Schedules for background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server
• Consistently demonstrated the capability of efficiently working on multiple projects with different hierarchy of professionals such as Owners, Leader, Project Managers, Testers, and Vendors and at different stress-levels
• Worked on python based test frameworks and test driven development with automation tools.
• Performing root cause analysis on data anomalies within the context of set business guidelines, documenting the analysis and providing updates to the ETL teams Involved in the Data Movement between Systems and validated the Business Requirements.

Environment: Informatica Power Center 8.6, Oracle 10g/11g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, Tableau Server v8/v7, AWS Redshift, Python, SharePoint, UNIX, Windows NT.

Systems Analyst

Responsibilities:

• Documented the complete process flow to describe program development, logic, testing, application integration, coding and implementation
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5
• Worked on cloud networking( AWS) in deploying the files.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.
• Involved in Data mapping specifications to create and execute detailed system.
• Involved in Functionality testing during the various phases of the development
• Validated the system End-to-End Testing to meet the Approved Functional Requirements
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.

Environment: Informatica Power center 8.5, Oracle 10g/11g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, Tableau Server v8/v7, SharePoint, UNIX, Windows NT,AWS.

ETL Developer

Responsibilities:

• Involved in Designing, developing, testing of parallel, server and sequence jobs using Datastage (8.5) and loaded the data into the SQL Server database.
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.
• Used Built-in, Plug-in and Custom Stages for extraction, transformation and loading of the data, provided derivations over DS Links.
• Used UNIX scripts to execute jobs and also used the DataStage Director for scheduling, executing and monitoring jobs.
• Implemented Shared container for multiple jobs and Local containers for same job as per requirements.
• Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage), XML Output stage.
• Debug, test and fix the transformation logic applied in the parallel jobs
• Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs.
• Extraction of test data from tables and loading of data into SQL tables

Environment: DataStage Enterprise Edition (8.1, Designer, Director, Manager, Parallel Extender), Windows Server 2003, IBM DB2 Mainframe SQL Server 7.0, GreenPlum, SQL, PL/SQL, Toad, Oracle 10g, Quality Center, SQL Loader, UNIX, Windows NT.

Data Analyst

Responsibilities:

• Involved in managing, Requirements gathering, architecting the different jobs and also writing complex queries and stored procedures
• Understanding the business functionality & Analysis of business requirements
• Involved in general db administration, query performance tuning and validating the existing schema.
• Consistently demonstrated the capability of efficiently working on multiple projects with different hierarchy of professionals such as Owners, Leader, Project Managers, Testers, and Vendors and at different stress-levels
• Involved in Functionality testing during the various phases of the development
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS

Environment: DataStage Enterprise Edition (7.5), Windows Server 2003, IBM DB2 Mainframe SQL Server 7.0, SQL, PL/SQL Oracle 10g, Quality Center, SQL Loader, UNIX, Windows NT.