SUMMARY:

• 8 years of IT experience in Business Requirements Analysis, Designing, coding and testing of Data Warehousing implementations across Financial, Insurance, transport and Telecom Industries.
• Data warehousing tools including Informatica (Informatica Server and Client tools like Designer, Server Manager, Workflow Manager, Workflow Monitor, Repository Manager), SQL Server DTS, API calls and advanced concepts.
• Experience in Data Modelling, making use of Dimensional Data Modelling, Star Schema/Snow Flake Schema (Ralph Kimball methodologies), ETL, OLAP and Report delivery methodologies. Expertise in OLTP/OLAP/VLDB System Study, Analysis and E - R modelling.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6.1/8.1.1/7.1 Reporting Tools (BI): Business Object XI R2, Cognos

RDBMS: Oracle 10g/9i, SQL Server 2005/2008, Big Data, Netezza (Knowledge only), MS-Access

Operating System: Linux, Window XP/2000/NT, DOS, Windows 2008, windows 7

Others: Pl/Sql, Sql, Toad, Erwin, Autosys, PVCs, SQL Loader, Perl, ArcGIS, 9.x, GIS, Control M Job Scheduler., Active Batch, Python script

Internet: J2EE (Servlet, JSP, EJB), Struts, XML/XSL/DTD, JMS, UML, RMI, Java Script, JDBC, Web Services and J2EE Patterns (Knowledge Only), NetBean IDE, Eclipse.

Languages: Java, Adobe Flex, Action Scripts, Google APIs.

Tools: Rational (Clear Case, Clear Quest, Requisite Pro, Rose)

PRPOFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Software Systems Engineer

Responsibilities:

• Confidential responsible for creating a Data Integrity monitor that was used by Verizon Reporting Team to track/Monitor Anomalies/data outliers from the Reporting database.
• Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Datamart.
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Created different transformations like Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, Normalizer transformations for loading the data into the targets.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control/auditing of different processes.
• Requirement Gathering and Business Analysis. Performed Business Discovery to define functional specifications.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Worked with Memory cache for static and dynamic for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using ERWin.
• Worked on Informatica PowerCenter tool - Source Analyzer, Mapping & Mapplet Designer and Transformation Designer.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle.
• Created Unix Shell Scripts wrote Scheduler utilities for automating the backup of Database/ Transaction log.
• Supported production issues.

Environment: Informatica PowerCenter 9.6/9.5/9.1, Oracle 11g/12c, SQL Server 2000, SSIS, PL/SQL, ERWin, ActiveBatch, Python, UNIX, TOAD, SQL*Plus, SQL*Loader, SQL Developer, Dseries, CA WA Workstation, Windows.

Confidential, Birmingham, AL

ETL INFORMATICA developer

Responsibilities:

• Involved in the analysis of source systems, gathering business requirements and identification of business rules.
• Designed and maintained the ETL processes using Informatica tool to extract the data from sources like Oracle, Flat files and sent the target Files to the client servers through FTP using UNIX scripts.
• Involved in developing waterfall model from requirement Gathering, production implementation to the project Maintenance, with identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into Target Data warehouse.
• Used deployment group to move Informatica Objects from Development to Testing and Production. Created and monitored sessions and batches using normal/bulk load options.
• Validating and developing ETL processes and improving the performance of existing ETL processes.
• Wrote the wrapper scripts to kick off the workflows from UNIX.
• CNTRL M scheduler is used to schedule the jobs to run daily.
• Supported production issues.

Environment: Informatica 9.5/9.1/8.6, Oracle 11g/10g, SQL Server 2005/2008, flat files, XML files, PL/SQL, SQL Queries, SQL Developer, Windows XP Enterprise edition, Toad, Erwin, UNIX Shell Scripts, Control-M.

Confidential, NY

ETL developer / Associate DBA Administrator

Responsibilities:

• Data maintenance and static transit data (such as schedules, stops) extraction, transformation and loading to SQL Server/ Oracle Database using Informatica as ETL tool.
• Used most of the ETL transformation to do ETL.
• Wrote SQL Scripts and Stored procedures to transform the data based on business requirements. Transferred data from XML source to the SQL Server database using batch load.
• Worked with business users, remote technical staff, and project team members in planning, designing, developing, implementing, and enhancing data warehouse applications, scripts, procedures, and metadata for relational databases.
• Used some of the UNIX utilities, example sort command to sort the data .Used Crontab to schedule jobs.
• Used dynamic SQL with PL/SQL and DBMS Packages with oracle. Created Universe with Business Objects. Used shell scripting to start the workflows and load the target tables. Performed TST/IQA Testing. Moved code to Production and provided production support and closed defects. Heavily involved in offshore support related work.
• Involved in data integration using APIs and WebServices.

Environment: Informatica 8.6.1, Microsoft SQL Server 2008, Oracle 10, UNIX, XML, GIS Data, Stored procedures, TSQL, TOAD.

Confidential, PA

Data Warehouse developer

Responsibilities:

• Performed a role of Data Warehouse Analyst/Production Support/ Administrator.
• Heavily involved in the production support for Informatica ETL Jobs.
• Created and manipulated BTEQ, Fast Load, and Mload Scripts.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Involved in analysis, design, development, maintenance, tuning, documentation, and implementation of enterprise logical data models and physical database objects.
• Worked with business users, remote technical staff, and project team members in planning, designing, developing, implementing, and enhancing data warehouse applications, scripts, procedures, and metadata for relational databases.
• Created maintainable and scalable "Extract, Transform, and Load" (ETL) code with Informatica tool to load and manipulate data in the corporate data warehouse
• Used Business Objects as one of the reporting tool. Extensively worked in creating and integrating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, and Prompts) with the data warehouse. Created Data Mart Reports using Complex Filters and Compound Metrics.

Environment: Informatica 8.6, SQL Server 2005, T-Sql, Teradata V2R6, Erwin, Stored Procedure, Windows 2003 Server, Teradata Manager, Teradata Administration, MLOAD, BTEQ, Business Object, Web Services, SOAP and REST .

Confidential, Newark, NJ

Responsibilities:

• Utilized SOA Architecture to get GIS data from Confidential Web server.
• Parsed the ESRI Shape Files to KML Format using Adobe Flex Builder 3.
• Used Google Map API for Flash SDK to develop a Flex code.
• Created Flex Application (SWF file) using Flex Builder which is being called through Java Servlet.
• Generated a Data Adapter which can be plugged back to Confidential for information retrieval at the time of Emergency.

Environment: XML, GIS Data, KML Files, ESRI Shape Files, Google Map APIS, Java, Apache Tomcat 7, RESTful Web Services, SOAP, SOA, Adobe Flex Builder 3, Action scripts.

Confidential, Reston, VA

ETL Developer / Solution Consultant

Environment: Informatica 7.1.1/7.1, Informatica Web Services, Oracle 8, Linux, Erwin, Toad, XML, SOAP Services, PL/SQL, Rational Suite(Clear Quest, Clear Case, RequistePro), Crystal Report 8.5, TOAD.

Confidential, CT

ETL Developer

Environment: Oracle 10g, MS SQL Server2000, Kalido, Linux, OLTP, OLAP, UNIX shell Scripting, Erwin, Toad, PL/SQL, SQL Loader, PVCS, Mercury Quality Center, Informatica Power Center 8.5.1, WS FTP , Business Object, Toad.