SUMMARY:

• A Datawarehouse Analyst professional with 4+ years of experience as ETL / BI Developer for analyzing, creating and managing data requirements, design and standards for a wide variety of projects. Strong analytical and dimensional modeling skills, along with experience in developing Extract, Transform and Load processes and data presentation layers for the end - user.
• 4+ years of professional IT experience in Software Analysis, Design, Development and Support for various applications.
• Strong ETL experience using Datastage and Informatica (Power Center/IDQ) in development of ETL mappings and scripts.
• Thoroughly proficient in SQL and PL/SQL, Oracle utilities & tools (SQL Plus/TOAD) and worked with various RDBMS (Teradata, Oracle, SQL server and MS-Access).
• Expert in Troubleshooting/Problem Solving skills.
• Having strong functional knowledge in Retail and Securities.
• Extensively worked with AutoSys & DAC Job scheduling tools and in UNIX and Windows environment.
• Hands-on experience in implementing Data warehousing solutions involving Dimension modelling with Star and Snow flake schema implementation.
• Worked in Enterprise and project-level Data Modeling for Data Warehouses (Dimensional and Relational) and Operational Data Stores.
• In-Depth knowledge in providing Business Intelligence Solutions in tools like OBIEE, Business Objects, Cognos and Hyperion Essbase.
• Good knowledge on statistical analysis to provide Business and data insights for Analytics and reporting using Data Visualization and Dashboards.
• Experienced in designing and writing on-demand UNIX shell scripts.
• Extensive experience in Release Management, Creation of Change Requests and Enhancements.
• Skilled at learning new concepts quickly, can work well under pressure and able to communicate ideas clearly and effectively.
• Excellent Analytical, Communication skills and Leadership qualities for working in a team.

TECHNICAL SKILLS:

Data Integration: Informatica (IDE/IDQ), DataStage, SSIS

Business Intelligence: Business Objects, OBIEE, Microstratergy, Cognos

Databases/RDBMS: Oracle 10g/9i, Teradata, MS SQL Server

Applications: TOAD, SQL+, ISM, Jaws

Programming: PL/SQL, Java, Unix Shell Scripting

Data Modelling: Erwin, Visio, ER Studio

Job Scheduling: DAC, Autosys

Languages: VB.NET, ASP, C, C+, C#, HTML/XML

Packages: MS Office

Operating System: Windows, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Analyzed the data warehousing functions and developed interrelated data warehouses comprising 3 ETL Applications.
• Extensively used DataStage and Informatica for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Handled the various aspects of the end to end life cycles to complex DW & BI projects.
• Designed SQL code for clients’ business process functionalities.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Provided suitable solutions to resolve data-related problems.
• Monitored DW, data extraction, transferring and loading activities.
• Created SQL Loader scripts to load legacy data into Oracle staging tables.
• Used complex SQL to query the database and was involved in SQL optimization of existing queries.
• Provided on-call support regarding production system.
• Developed daily schedules for jobs to be run according to various job dependencies.
• Involved in monitoring the workflows and in optimizing the load times.
• Migrated mappings from Development to Testing and from Testing to Production.
• Conducted tests and provided sound solutions to data warehousing problems.
• Created various Documents such as Source-to-Target Data Mapping Document, and Unit Test Cases Document.
• Troubleshooting of ETL jobs and addressing production issues like performance tuning and enhancement.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through Autosys.
• Prepared UNIX Shell Scripts and scheduled them in AUTOSYS for automatic execution at the specific timings.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Developed PL/SQL procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Participated in the Incident Management and Problem Management processes for root cause analysis, resolution and reporting.

Environment: Datastage 8.0, Informatica IDE (8.6/9.6), SSIS, Oracle 9i/10g, OBIEE, DAC, Autosys, Unix, ISM, Essbase, Jaws, MS SharePoint, TOAD, SQL, PL/SQL, SQL Loader.

Confidential

Informatica Developer

Responsibilities:

• Performed analysis/design/development/unit testing for IDQ upgrade from Trillium.
• Gathered highly researched data from various useful resources and performed Data quality analysis to undertake actions and make improvements within the data.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Determined the end user requirements and planed data warehousing policies in its accord.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database and existing Jobs.
• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Identified the feasible alternative approaches, systems and equipment reduce cost, improved efficiency while meeting the expectations.
• V alidated ETL mappings and tuned them for better performance and implemented various Performance and Tuning techniques.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets using ETL tools.
• Performed Unit Testing at various stages by checking the data manually.
• Performed Data Analysis and Data validation by writing SQL queries.
• Worked independently and completed assigned project responsibilities under limited supervision and aggressive deadlines.

Environment: Informatica IDE 8.5, Informatica DQ, Teradata V12, Oracle 9i, Microstratergy, MS Visio, MS Office, AS/400, Unix Shel Script.