SUMMARY

• 8+ years of IT experience with special emphasis on development, analysis and design of ETL methodologies in all the phases of the Data Warehousing life cycle with knowledge in ETL, Data Warehousing, Business Intelligence, OLAP & OLTP system technologies.
• Over 3 years of experience in Data Visualization, Analytics, Maintenance of Business Intelligence, and the related Database Platforms.
• Excellent knowledge on data warehousing applications, directly responsible for the 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.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Created metrics, attributes, filters, reports, and dashboards. Prepared advanced chart types, visualizations and complex calculations to manipulate the data.
• Worked with Data Migration, Data Conversion in diverged environment like DB2 UDB, Oracle, SQL Server and complex files.
• Extensive experience on masking the 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 the principles 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.
• Experienced in writing system specifications, translating user requirements to technical specifications.
• 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.

TECHNICAL 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: Erwin 4.2

SQL Server Tools: 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.

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 and MS- Access.

PROFESSIONAL EXPERIENCE

Confidential, Elmhurst, IL

ETL /BI 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 the needs of High Stake Clients.
• Coordinated with data modeler and database administrator to understand the business process of the data warehouse model.
• Coordinated with data modeler and database administrator to understand the business process of the data warehouse model.
• Involved in scheduling the DataStage jobs using Control-M.
• Extracted the source data from different sources like Complex Fixed width Multiple record type flat files(from Mainframes) and DB2 Databases.
• Extracted the 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 the data to prohibit sensitive information from visibility.
• User tables were created so that other user information is masked from becoming visible to unauthorized users.
• Excellent knowledge 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 Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Involved in creating complex SQL Queries for extracting the data from the database, Data Validations and Cleanup Scripts etc.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects.
• Developed calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Worked on building queries to retrieve data into Tableau from IBM DB2 and, and developed ETL jobs for loading data into Target Database.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server with the usage of quick filters for on demand needed information.
• 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.1, (Designer, Director, Administrator), IBM DB2, Control-M, Cognos, Tableau 9, Oracle 11g-Release 2, SQL Server 2005/2008, UNIX Korn Shell scripting, SQL Server Analysis Services, MS Excel 2003, Visual Studio 2005,.NET Frame Work, 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 the existing tool and participated in meetings with the business users to gather and writing technical specs.
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the 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 the 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 the data definitions and created the target tables in the database.
• Wrote Korn Shell scripts to schedule batch jobs to obtain data overnight from various locations, through Scheduling tool called Control-M.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Unit tested the mappings to check for the 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 the 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 the needs of end user requirements so that every possible query can be achieved.
• Involved in the 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 the Source to target mappings with the 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 the output file.
• Involved in Test case writing and code review.
• Used DataStage version control to move the 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 the 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 the 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 the 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:

• Gathered 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 the location of data, index, and transaction log files on the 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 the new SDLC based on the Agile Unified Process, especially from the 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 the process using UML to create behavioral and structural diagrams.
• Developed detailed Developer specification to reflect technical details of the business requirements.
• Performed data analysis by using SQL queries using the DB Artisan tool.
• Extensive experience in using collaborative tools like Mercury Quality Center to facilitate development across disparate teams.
• Provided management support to the 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 the business and technical requirements for the Network applications which interface with the OSS/BSS applications.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• 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 that application meets their requirements.
• Assisted the Account Management people in reviewing the account of the customers.
• Assisted QA team for testing.
• Documented and delivered Functional Specification Document to the project team.
• Worked with team to deliver business use cases according to the 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.