SUMMARY:

• Software professional with 3 years of experience in the analysis, design and development of Data warehouse and Business Intelligence applications.
• Have sound knowledge and experience in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.
• Experienced in all aspects of Software Development Life Cycle (Agile & Waterfall).
• Experienced in interacting with business analysts and business users to identify information needs and business requirements for data analysis.
• Expertise in analyzing and documenting Business Requirement documents (BRD), Functional Requirement Documents (FRD) and System Requirement Specification (SRS).
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Expertise in Data Flow Diagrams, Process Models, and ER diagrams with modeling tools like ERWIN & VISIO.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Proficient in gathering business requirements and translating them into technical/mapping specifications, providing workable solutions to business problems.
• Ability to extract and manipulate data over large and complex relational data - set using SAS, R and SQL.
• Proficient with different data base systems like SQL Server, Teradata, Oracle, Netezza and DB2.
• Experienced in maintaining and creating database objects like tables, views, indexes, sequences, synonyms etc.
• Expert in T-SQL query development skills, advanced performance tuning and query optimization.
• Experience in SQL programming (writing T-SQL queries with DDL and DML commands, stored procedures, indexes, triggers and view) or relational database tools such as Business Objects.
• Experienced in System Analysis, Design, Development, Implementation, Maintenance, and Testing of Data Warehouse and Data Integration Applications using ETL tools like Informatica Power center 9.6/9.1/8.x/7.x/6.x.
• Expertise in designing confirmed and traditional ETL Architecture involving Source data warehouse and database systems like Teradata(14.x), Netezza(6x), Oracle(10g-11g), Flat Files (fixed width, delimited), DB2, SQL server(2008), XML and Target databases.
• Extensive Experience in designing and developing complex mappings applying various transformations such as Lookup, Source Qualifier, Update Strategy, Router, Sequence generator, Aggregator, Rank, Stored Procedure, Filter, Normalizer, Joiner, Expression, Union, SQL and Sorter transformations.
• Experienced in using various Informatica Power center Client components Designer/ Workflow manager /Workflow Monitor/Repository Manager.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Worked closely with the Business Objects reporting team to design the data mart tables for Business Objects reports.
• Experienced in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Proficient in ETL Unix shell script processes, data loading, manipulation using UNIX shell scripting, SQL.
• Extensively worked on backend testing and well versed with SQL, PL/SQL queries to run the data integrity tests
• Experienced with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, SQL Assistant.
• Experience in doing Tuning of Teradata Queries using Explain plan.
• Hands on experience in Tuning Mappings, Identifying and resolving Performance bottlenecks in various levels such as sources, targets, mappings, and scheduling in AUTOSYS, CONTROL M and wrapper script.
• Extensively worked with end users on the UAT of the Data warehouses and Data Marts.
• Experienced in Architecture process of creating Schema objects with MicroStrategy Developer like simple and compound Facts, Attributes, Fact extensions, Hierarchies, Transformations.
• Extensive experience with design and development of Tableau visualization solutions.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau reader in various versions of Tableau (7.x/8.x/9.x) and VizQL, SQL, PL SQL and UNIX shell scripting.
• Harnessing best ways in designing stunning visualizations using tableau software, publishing and presenting dashboards on web and desktop platforms. Troubleshooting skills, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Optimized tables, View, SQL definitions to enhance query execution using Oracle, SQL specific utilities for the reporting environment in MicroStrategy
• Experienced in designing & development of Report Service Documents, Web/ Mobile/ Visual Insights Dashboards with multiple datasets.
• Experience in MS words, excel and power point.
• Experience in a vast array of statistical and numerical methods of analysis and modelling Such as linear regression analysis including nonlinear regression, mixed models, survival analysis and logistics regression.
• Extensively worked in Windows and UNIX Platforms.
• Excellent communication skills and ability to work in group as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9. 6.1 /9.5/9.1/8. x/7.x/6.x, IDE, IDQ

BI Tools: Microstrategy 10.x,Tableau (Desktop, Server), SSRS/SSAS

Operating Systems: Unix, MS-DOS, Windows 7/Vista/XP/NT/2000/2003

Databases: Oracle (10g-11g), DB2, SQL Server 2012/2011/2008/2005, Teradata (14.x), Netezza (6.x), SQL, RDBMS, Oracle.

Programming Skills: PL/SQL, Python, Ruby and Shell script

Database Tools: TOAD, SQL*Plus, SQL Developer, PL/SQL Developer, Teradata SQL assistant, WinSQL

Data Modeling: Sybase Power Designer 15.2

Schedulers/Scripting: UNIX Shell Scripting, TIDAL, Autosys, Control-M

Continuous Integration(CI)/Continuous Deployment(CD) Tools: ANT, Maven Hudson, Jenkins, Bamboo, Nexus, Deploy Tools Chef, Puppet, Saltstack.

Platforms: Windows,Unix,Linux

Defect Tracking: JIRA, Quality Center (QC)

Methodologies: SDLC (Agile, Waterfall), Six Sigma, CMMI

UML Diagrams: Use Case Diagram, Interaction diagram, Activity Diagram, Class Diagram, Sequence Diagram, Component Diagram, and Deployment Diagram

PROFESSIONAL EXPERIENCE:

Confidential, Westlake, TX

Business Intelligence Developer

• Extensively involved in requirements gathering, writing ETL Specifications and preparing design documents.
• Analyzed and detected the data quality issues and recommended corrective courses of action.
• Development of Mappings based on given requirements and business rules to load data from desired source tables to target tables.
• I worked for Development, Enhancement & Supporting EDW which is on Teradata.
• Worked with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model.
• Worked on TOAD and Oracle Developer to prepare Oracle Queries to validate the data in both source and target databases.
• Interaction with Business SME's on requirement gathering, understanding the business and functional requirements.
• Collaborated with the end users to identify technical requirements for the development project based on their business requirements.
• Developed Informatica mappings, reusable transformations and created PL/SQL Stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.
• Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements.
• Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.
• Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Unconnected), Expression, Update Strategy, Transaction Control and Sequence Generator.
• Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables.
• Worked with Huge data sets to load Fact Tables.
• Experienced in doing performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating the with tuning methods.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections. Created complex mappings to extract transform and load data into data warehouse.
• Involved in Performance tuning of sessions and mappings for better performance
• Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load in to Teradata Ware House.
• Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata Sql.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems .
• Involved in complete SDLC ETL process from development to testing and production environments.
• Draw upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Writing and Implementing test scenarios, test cases for system and regression testing in multiple environments.
• Created dashboards with charts, graphs that convey meaningful data and insights using Power View.
• Participated in BI team meetings to discuss the user requirements.
• Designed Logical data model and Physical data models for the MicroStrategy applications.
• Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica9.6/8.6/7.1, Oracle11g/10g/9Teradata 14/12, Unix Shell scripting,PL/SQL Developer, Power BI.

Confidential, Fountain valley, CA

Informatica Developer/Teradata Developer

• Analyzed and understood business and customer requirements by interacting with Business Analysts, Client Analytics team and Subject Matter Experts (SME).
• Design, develop and provide unit test data loading and data transformation programs related to Netezza Data Warehouses and Data Marts.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• ETL processes to transfer data from relational database and flat files common staging tables.
• ETL process to transfer data from staging tables to Star Schema.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Prepared design document for data flow process, LLD, HLD, Project end User Manual and Operations Hand off guide.
• Created logical and physical data models using TDWI (The Data Warehousing Institute) best practices to ensure high data quality and reduced redundancy. Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Java, Stored procedure, and Sequence generator transformations.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Handling day to day Informatica administration tasks such as components migration tasks, Scheduling and Monitoring Informatica repository backups.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Developed Teradata BTEQ scripts to populate target tables, Responsible for data profiling, data mapping, data loading, and data validation.
• Loaded data in to the Teradata tables using Teradata Utilities BTEQ, Fast Load, Multi Load, and Fast Export, TPT.
• Worked with offshore associates and ensure high quality code delivery according to the requirements specified by business users.
• Interact directly with the Business Users to accommodate any changes, if there are any, so as to minimize/eliminate last minute changes.
• Execution/Implementation of the project in accordance with End User’s expectations and making sure that the user is fully satisfied with the end results.
• Coordinated in daily team meetings, technical code review meetings and interacted with business people for better technical solutions and proposed ETL strategy based on Agile Methodologies.
• Created UNIX shell scripts to handle pre and post session tasks.
• Created User defined functions (UDF) to reuse the logic in different mappings.
• Implemented the Error Records Handling mechanism.
• Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Worked on configuring Informatica and file processing Job schedules for CONTROL-M scheduler.
• Identified and mapped Source tables and columns required to create a MicroStrategy project.
• Employed MicroStrategy Desktop in designing the MicroStrategy projects.
• Configured reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.

Environment: Informatica Power Center 9.6, Informatica Power Exchange, Oracle 10g/9i, Control-M Scheduler, Windows-XP (Client), Teradata 14x, PL/SQL Developer, Teradata SQL Assistant, Netezza 7.

Confidential, Atlanta GA

ETL Developer

• Involved in business requirement analysis and prepared functional requirement documents.
• Involved in the ETL technical design discussions and prepared ETL high level and Low level technical design documents.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Java, Stored procedure, and Sequence generator transformations.
• Designed and developed Complex ETL Informatica mappings. Scheduled and Managed Informatica sessions.
• Extensively worked on Profiling and Parsing the Unstructured data coming out of Ryan Solutions data using various Informatica complex Functions.
• Used Change Data Capture (CDC) to implement Incremental Data Extraction so that only the modified and new records will be extracted to the destination rather than full extraction.
• Extensively worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• Designed, Developed and Deployed UNIX shell scripts.
• Coordinated and worked closely with architects, operations, and business units to build and deploy.
• Implementing data quality management solutions that manage millions of customer transactions.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Established test environments and test data and advocate the use of common re-usable functions, services and data.
• Participated in quality assurance activities like reviews, walkthroughs etc.
• Performed extensive risk assessment prior to production implementations and carried out validations for post implementation to ensure successful execution monitoring performance.
• Developed Tableau Data Extracts from the above mentioned data sources using Pentaho Data Integration ETL tool.
• Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.

Environment: Informatica Power Center 9.5, MS SQL Server Version 11, MS SQL Server Management Studio, MS Excel, UNIX.

Confidential

Entry Level Trainee & JR ETL Developer (Internship Third year program)

• Analyzed and understood business and customer requirements by interacting with Business Analysts, Client Analytics team and Subject Matter Experts (SME).
• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Java, Stored procedure, and Sequence generator transformations.
• Handling day to day Informatica administration tasks such as components migration tasks, Scheduling and Monitoring Informatica repository backups.
• Interact directly with the Business Users to accommodate any changes, if there are any, so as to minimize/eliminate last minute changes.
• Involved in Requirements capturing and Design of Reports
• Provide support to ETL applications and keep the data service available to users all time.
• Monitoring production ETL jobs and fixing the issues within SLA window.
• Perform Unit, Assembly and System testing for the change requests proposed.
• Implemented the Error Records Handling mechanism.
• Created UNIX shell scripts to handle pre and post session tasks.
• Involved in different phases of testing like Unit, Functional, Integration and System testing.
• Provided Adhoc-Reporting and Analytical services to Business Partners based on key priorities
• Prepared documents like Deployment Doc, Estimation Reports, Tractability Reports, Development tracking report and weekly status reports (WSR).

Environment: Informatica Power Center v9.0.1, Informatica Power Exchange, Informatica Data Quality (IDQ), Oracle 10g/9i, Sybase Power Designer 16.0.