SUMMARY

• 8+ years of IT experience in the field of Business/Data analysis, ETL Development, Data Modeling, and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management
• Extensive experience in using databases like Teradata, DB2, SQL Server 2005 ad 2008,Oracle11g/10g/9i(Including SQL,SQL*Plus, SQL Loader).
• Good knowledge on Multi set volatile tables, Set tables, Global temporary tables, Derived tables.
• Production job scheduling on UNIX through Control - M scheduling tool and also using Datastage.
• Performed data extraction, aggregation, and quality checking from multiple big data sources to create and monitor tests and programs.
• Involved in all the stages of Software Development Life Cycle.
• Proven track record in troubleshooting of Datastage (ETL) jobs and addressing production issues like performance tuning and enhancement.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Good knowledge on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Complex Flat Files, Aggregator, Join, Transformer, Sort, Remove Duplicates, Merge, Filter and Lookup.
• Worked with Local Containers, Shared Containers and Job Sequences.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Strong experience in UNIX Shell scripting (Korn, BASH, and CSH) as part of file manipulation, Scheduling and text processing.
• Experience on DW/Business Intelligence tools.
• Experienced in writing system specifications, translating user requirements to technical specifications.
• Experience with the Build, Migrate and Shakeout process of the development code to higher environments (Sys Test, UAT, and PROD).
• Experience on IBM Web Sphere 8.1/8.0 Quality Stage.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Excellent communication skills.
• Aptitude for analyzing, testing, debugging code, identifying problems, creating solutions and documentation.
• Multilingual, highly organized, detail-oriented professional with strong technical skills.
• Good aptitude for problem solving and logical analysis.
• Highly motivated, team player with excellent interpersonal and communication skills, organized and quick learner.

TECHNICAL SKILLS

ETL Tools: ASCENTIAL DATASTAGE 7.X/8.0/IBM InfoSphere Information Server 8.7Quality stage, Abinitio.

Databases: ORACLE 7.X/8i/9i/10g/11g, SQL SERVER 2008, DB2 UDB 7/8/9.7, Teradata V2R5/V2R6/V12/V13.

Languages: C, C++, Java, UNIX Shell Programming, SQL, PL/SQL

Data Modeling: Star Schema Modeling, Snowflake Modeling, FACT and Dimension tables, Erwin 7.2

Reporting Tools: Business Objects/Web Intelligence, Micro strategy.

Operating Systems: Windows NT4.0/2000/XP/Win 7, MS-DOS, UNIX (Solaris, Linux, AIX, HP-UX)

Tools: Autosys, Control M, SQL*Loader, Quality Center Tool.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior Data Analyst

Responsibilities:

• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Participated in the Analysis, Design and Development Phases of report development.
• Worked in Recoveries team which involves in Asset Sales, Legal and bankruptcy businesses.
• Created new reports based on requirements. Responsible in Generating Weekly ad-hoc Reports.
• Performed ad hoc analytics on large datasets using various tools and techniques.
• Generated Quarterly Audit reports for InfoSec Teams.
• Responsible for moving Timer jobs to Production environment.
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Performed data extraction, aggregation, and quality checking from multiple big data sources to create and monitor tests and programs
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives.
• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day Branch Operations.
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities
• Involved in Branch Operations specific data-mart as part of a Business Objects Universe which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Generate weekly and monthly asset inventory reports.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Involved in performing the analysis for all the Projects/Maintenance Requests.
• Support project through all stages of design, development and testing
• Created Multi set volatile tables, set tables as per requirement.
• Extensive usage of Inner and Outer joins for retrieving data from multiple tables.
• Collected statistics on all the tables used in the query as needed.
• Worked with Teradata BTEQ to run the scripts.
• Performance tuning the long running queries.
• Performed Data verification and validations to evaluate the data retrieved is apt according to the data requirements and specifications.

Environment: Teradata V13, Oracle 11g, SAS, UNIX, Erwin, Putty, Ultra Edit, Windows XP,MS Excel, MS Power point.

Confidential, Rancho Cordova, CA

Sr. ETL DataStage Developer/Analyst

Responsibilities:

• Involved in multiple projects Loyalty2013, Connecting consumers, Optics& Lens.
• Directly interacted with the Business users for collecting the requirements.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Extensively worked on DB2 and Oracle tables handling large volumes of customer data.
• Used the Data Stage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different tables.
• Extensively worked on modified the shell scripts in different environments.
• Extensively used Sequential files, Oracle, DB2, Complex Flat Files, Sort, Funnel, Remove Duplicates, Merge, Aggregator, Pivot, FTP and created datasets.
• Done performance tuning for already existing jobs and also performed query optimization.
• Involved in production deployment process of DataStage jobs and shell scripts.
• Built Sequencer jobs to synchronize the control flow of multiple activities in a job sequence and Scheduled for Automation.
• Wrote the Design documents and specifications in accordance with Confidential ’s design frameworks and best practices.
• Undertook Change and Enhancements request.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Used Version Control to keep track of multiple versions of Datastage jobs and promote latest job versions from Development to QA and Production environments.
• Extensively worked on Migrating Datastage jobs form Infosphere DataStage 8.0.1 to InfoSphere Information Server 8.7 version.
• Also provide Production support for jobs already in use and rigorously worked on resolving errors in production environment.

Environment: IBM InfoSphere Information Server 8.7, IBM Infosphere DataStage 8.0.1, IBM AIX -5.3, Eclipse, Shell Scripts, Oracle 10g, Sql Plus, DB2 9.7, Unix, Windows XP SP-3.

Confidential, Richmond, VA

ETL Tester/ Data Analyst

Responsibilities:

• Involved in designing and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies based on business requirements and Design documents.
• Responsible of creating test scenarios in Quality center and requirements mapped to each test scenario.
• Worked with the Developers and the Test Lead to verify the Test Cases.
• Performed Development Integration, System Integration, End to End and User Acceptance Testing for the data services.
• Prepared the Test Data to mock up all the Test Scenarios and Test Cases.
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that the data elements and attributes are properly named.
• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management supports to the development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Developed complex SQL Queries to validate the Test Cases.
• Performed Positive & Negative testing for system validations.
• Performed Functional testing, Batch testing, System testing Performance testing and Regression Testing to see the entire functionality.
• Involved in User Acceptance Testing (UAT) and also involved in end to end testing.
• Involved in application security testing for securing the application with proper authentication & authorization.
• Loaded the Test Data into the Databases to prepare for the execution of Test Cases.

Environment: ABINITIO, HP Quality Center9.2, SQL, PL/SQL, Oracle 9i/10g, MS SQL 2000/2005, SQL Server Integration Services, Teradata, UNIX, Korn Shell Scripting, Windows.

Confidential, Herndon, VA

ETL Developer/Analyst

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Performed Data Analysis utilizing SQL programming and analytical skills
• Worked on retrieving data by programming with SQL code and created functions
• Developed and Administered the Physical Layer, Business Model and Mapping Layer and presentation layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Prepared design and analysis documents.
• Wrote PL/SQL Stored Procedures to check the status of the target database before moving records into it.
• Used sales force dot com(SFDC) for change request(CR) tracking.
• Responsible for updating project manager regarding status of development efforts
• General Procedures and functions for various user requirements were coded, tested and implemented.
• Participated in the detail design of the specifications of the database and the associated Screens.
• Used the DataStage Director and its run-time engine to schedule and run the parallel jobs, testing and debugging its components and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Involved in creating functional and scope documents for ETL processes.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse. Developed DataStage parallel jobs to load data from sequential files, flat files and Oracle.
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Excellent communication skills.

Environment: SQL Server 2005, PL/SQL, Oracle 8i, Toad, UNIX, MS-Office, Autosys, Abinitio.

Confidential 

Intern SQL Developer/DATA Analyst

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Performed Data Analysis utilizing SQL programming and analytical skills
• Worked on retrieving data by programming with SQL code and created functions
• Developed and Administered the Physical Layer, Business Model and Mapping Layer and presentation layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Prepared design and analysis documents.
• Wrote PL/SQL Stored Procedures to check the status of the target database before moving records into it.
• Used sales force dot com(SFDC) for change request(CR) tracking.
• Responsible for updating project manager regarding status of development efforts
• General Procedures and functions for various user requirements were coded, tested and implemented.
• Participated in the detail design of the specifications of the database and the associated Screens.
• Excellent communication skills.

Environment: SQL Server 2005, PL/SQL, Oracle 8i, Toad, UNIX, MS-Office.