EXPERIENCE SUMMARY:

• 8+ years of IT experience with special emphasis on development, analysis and design of ETL methodologies in all teh phases of teh Data Warehousing life cycle with noledge in ETL, Data Warehousing, Business Intelligence, OLAP & OLTP system technologies.
• Over 4 years of experience in Data Visualization, Analytics, Maintenance of Business Intelligence, and teh related Database Platforms.
• Excellent noledge on data warehousing applications, directly responsible for teh Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Extensive background using Oracle development tool set (Including PL/SQL, SQL Loader, PL/SQL developer).
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets.
• Excellent experience with databases such as Oracle, Teradata,Netezzain developing SQL, PL/SQL packages as per business needs.
• Created metrics, attributes, filters, reports, and dashboards. Prepared advanced chart types, visualizations and complex calculations to manipulate teh data.
• Worked with Data Migration, Data Conversion in diverged environment like DB2 UDB, Oracle, SQL Server and complex files.
• Extensive experience on masking teh sensitive data.
• Proven track record in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
• Experience in Parallel Extender (DS - PX) developing Parallel jobs using various stages including Aggregator, Join, Transformer, Sort, Merge, Filter and Lookup.
• Demonstrated ability in dealing with different stages (Hash, Shared Containers, and Merge etc).
• Strong understanding of teh principals of DW using Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Experience in designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.
• Strong experience in UNIX Shell scripting (Korn, BASH, and CSH) as part of file manipulation, Scheduling and text processing.
• Knowledge in Hadoop file System HDSF and MapReduce.
• Extensive experience in MS- SQL 2005, 2008, PL/SQL, SQL, Procedures and Oracle 9i.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Played significant role in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
• Multilingual, highly organized, detail-oriented professional with strong technical skills.
• Good aptitude for problem solving and logical analysis.

SUMMARY OF SKILLS:

Tools: Ascential DataStage 9.1, 8.x /7.5x2/7.x, Quality Stage, MS Visio, Crystal reports, Tableau, Microsoft office 2003/2007/2010.Data model

SQL Server Tools: Erwin 4.2 Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS.

Operating Systems: Windows XP, NT, Windows 95, MS-DOS, UNIX.

Computer Languages: PL-SQL, C, Visual Basic 6.0, XML, JavaScript, VBScript, Unix Shell Scripts, Control-M. Dimensional

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

RDBMS: ORACLE (8, 9i, 10g, 11i), MS SQL Server, IBM DB2, Teradata and MS- Access, Netezza.

PROFESSIONAL EXPERIENCE

Confidential, Elmhurst, IL

ETL Consultant

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Fulfilled High Priority tickets with SLA of 3 hrs to meet teh needs of High Stake Clients.
• Coordinated with data modeler and database administrator to understand teh business process of teh data warehouse model.
• Coordinated with data modeler and database administrator to understand teh business process of teh data warehouse model.
• Involved in scheduling teh DataStage jobs using Control-M.
• Migrated jobs from DataStage 8.5 to DataStage 9.1 and enhanced jobs to utilize teh new functionalities of 9.1.
• Extracted teh source data from different sources like Complex Fixed width Multiple record type flat files(from Mainframes) and DB2 Databases.
• Data masking rules were applied on teh data to prohibit sensitive information from visibility.
• Extensively used Netezzaworkbench to perform various DDL, DML etc. operations on Netezzadatabase.
• Excellent noledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Great ability to create and manage various database objects like tables, views.
• Created Maintenance Plans and setup log files to monitor jobs.
• Created DataStage mappings and schedule them in Active batch to load data from various OLTP sources intoNetezzastaging tables.
• Actively involved in migratingNetezzacode and data into large scale distributed data processing.
• Developed calculated fields for teh business logic, field actions, sets and parameters to include various filtering capabilities and to provide drill down features for teh detailed reports.
• Worked on building queries to retrieve data from various sources and developed ETL jobs for loading data into Target Database.
• Worked with DBA’s to address complex issues like identifying Deadlock, Memory issues, and PLSQL Packages, creating indexes, constraints and triggers.
• Involved in Source system analysis and Requirement Gathering meetings and created Design specification and Mapping Documents for ETL Process.
• Involved in creating detailed design documents, Technical Design documents and Mapping documents and Test Cases jobs.

Environment: DataStage 9.1,8.5, (Designer, Director, Administrator), IBM DB2, Netezza, Control-M, Cognos, Oracle 11g-Release 2, SQL Server 2005/2008, UNIX Korn Shell scripting, SQL Server Analysis Services, MS Excel 2003, Visual Studio 2005, SharePoint.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Designed, developed and monitored DataStage Parallel jobs using DataStage8.1(Enterprise Edition).
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Developed ETL routines based on technical requirements.
• Managed star schema/snowflake data warehousing projects for medium and large corporations in diverse industries.
• Analyzed teh existing tool and participated in meetings with teh business users to gather and writing technical specs.
• Requirements and design goals of data warehouse.
• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Complicated jobs were developed to include changing business rules and perform quality checks on data received from external vendors.
• Used teh DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Experience Analyzing, Sourcing and Parsing complex Flat files and XML.
• Defined teh data definitions and created teh target tables in teh database.
• Wrote Korn Shell scripts to schedule batch jobs to obtain data overnight from various locations, through Scheduling tool called Control-M.
• Mapped teh source and target databases by studying teh specifications and analyzing teh required transforms.
• Unit tested teh mappings to check for teh expected results.
• Experience in conducting data validation using SQL.
• Architected and managed implementation of Oracle star schema/snowflake conformed data marts.
• Involved in development of UNIX shell scripts for Batch jobs etc run.
• UNIX Shell scripting (Korn, BASH, and CSH) as part of file manipulation, Scheduling and text processing.
• Prepared test docs which involved preparation of test data, test case and unit testing of teh jobs .
• Provided data modeling support for numerous strategic application development projects.
• Created various classes and objects for Universe. Measure, Dimension and Detail objects were created to meet teh needs of end user requirements so dat every possible query can be achieved.
• Involved in teh designing and development of Universes, Classes and Objects.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.

Environment: DataStage8.1, (Designer, Director, Manager, Parallel Extender), UNIX Shell Scripts, XML, DOS, SQL Server 2005, Windows 2000/2003,MS Access 2000/2003/XP, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services. PL/SQL, IBM DB2, MS Access, Control-M.

Confidential, Rockville, MD

ETL /BI Consultant

Responsibilities:

• Data analysis, data mapping, extract, transformation and load.
• Involved in creating Conceptual design which gives teh Source to target mappings with teh business transformation rules.
• Worked with functional staff to translate business requirements into appropriate logical and physical data structures.
• Developed source to target mappings with transformation rules.
• Used various stages like pivot, sequential file, sort, merge, pivot, modify, aggregator etc.
• Involved in production support on rotational basis.
• Developed job sequence and implemented restart ability using various checkpoints.
• Extensively worked on DataStage Director, DataStage Manager.
• Written Unix Shell Script for creating Header and Trailer for teh output file.
• Involved in Test case writing and code review.
• Used DataStage version control to move teh jobs from DEV to SYS to PROD.
• Developed and deployed Control-M jobs.
• Created parallel extender jobs to extract data from different source files, transform teh data using stages like Transformer stage.
• Generated various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS) for various projects.
• Created standard report subscriptions.
• Created report snapshots and cache for better performance.
• Developed and rendered monthly, weekly and daily reports as per teh requirement and gave roles, user access with respect to security in Report Manager.
• Experience in conducting data validation using SQL.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Prepared test docs which involved preparation of test data, test case and unit testing of teh jobs.
• Provided data modeling support for numerous strategic applications.

Environment: Ascential DataStage 7.5, SQL Server Integration Services, SQL Server Reporting Services, Windows Server 2003, SQL Server, Oracle 9i, SQL, PL/SQL, UNIX Shell Scripts, Erwin 4.1.

Confidential, PA

System Analyst / Intern

Responsibilities:

• Gatheird business requirements by driving user-group meetings and working with various global, cross-functional and virtual teams.
• Monitoring database servers for any unexpected errors/failures, providing 24 X 7 on call support for production environment.
• Creation of new databases, planning teh location of data, index, and transaction log files on teh disks.
• Created views, stored procedures, functions and triggers.
• Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Involved in mentoring specific projects in application of teh new SDLC based on teh Agile Unified Process, especially from teh project management, requirements and architecture perspectives.
• Recorded retention stored in Knowledge Link. Ad Hoc reporting, Admin for MS Project 2003, Excel dbase and pivot tables, Clarity and MS Project Server Admin duties.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Involved in all phases of software development life cycle in RUP framework.
• Used Rational Rose to model teh process using UML to create behavioral and structural diagrams.
• Developed detailed Developer specification to reflect technical details of teh business requirements.
• Performed data analysis by using SQL queries using teh DB Artisan tool.
• Extensive experience in using collaborative tools like Mercury Quality Center to facilitate development across disparate teams.
• Provided management support to teh off-shore End to End Integration / Regression Test Team.
• Prepared UAT Materials UAT Test Cases to include various steps involved for UAT and to have proper coverage of requirements.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Windows Server 2003, UNIX Shell Scripts, Oracle 9i, 10g, SQL, SQL*Loader, PL/SQL, MS Access.

Confidential

Test Engineer

Responsibilities:

• Responsible for collecting and documenting teh business and technical requirements for teh Network applications which interface with teh OSS/BSS applications.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using teh UML (Unified Modeling Language) methodologies.
• Performed teh requirement analysis, impact analysis and documented teh requirements using Rational Requisite Pro.
• Developed teh test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product noledge.
• Used MS Office for creating Vision, Use Cases, and Supplementary Specification Documents.
• Assisted Test Lead, Testers understanding business process and help them successful completion of Testing.
• Documented process flows, process dependencies, and production environment configuration.
• Collected requirements from cross functional business community.
• Facilitated JAD sessions.
• UAT testing performed along with call center managers to make sure dat application meets their requirements.
• Assisted teh Account Management people in reviewing teh account of teh customers.
• Assisted QA team for testing.
• Documented and delivered Functional Specification Document to teh project team.
• Worked with team to deliver business use cases according to teh project requirements.
• Worked closely with project manager in handling whole project.

Environment: Windows, UNIX Shell Scripts, HP Quick Test Professional, Load Runner, SQL, PL/SQL, MS Access.