SUMMARY

• Around 8 years of IT experience and Technical proficiency as Data Analyst in ETL, SQL coding, Data Modelling and Data Warehousing involved with Business Requirements Analysis, Application Design, development, testing, documentation and reporting. Implementation of full lifecycle in Data warehouses and Data marts in various industries.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobilein various versions of Tableau 6, Tableau 7 and Tableau 8.x.
• Worked extensively on SQL server, ETL tools include INFORMATICA.
• Good Knowledge and hands - onexperience on Oracle(SQL/PLSQL),MS Access,databases (MySQL,Oracle, SQL Server)
• Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop versions 8.0, 8.1 and 8.2.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
• Experience in gathering and writing detailedbusiness requirementand translating them intotechnical specificationsanddesign.
• Extensive knowledge in Business Intelligence and Data Warehousing Concepts with emphasis onETLand System Development Life Cycle (SDLC).
• Extensive knowledge onData Profilingusing Informatica Developer tool.
• Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures
• Experience in Data warehousing, Data Architecture &Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center 9.x/ 8.6.0/8.1.1/7. x/6.x/5.x.
• Proficiency indesign and developing the ETL objects using Informatica Power centerwith various Transformations like Joiner, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Router, Rank, normalizer transformations etc.
• Involved inData Migration projects from DB2 and Oracle to Teradata. Created automated scripts to do the migration using UNIX shell scripting, Oracle/TD SQL.
• Proficient with Data Warehouse models like Star Schema and Snowflake Schema.
• Involved in all aspects of ETL-requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, designing various mappings, developing mappings, unit testing, integration testing, regression testing and UAT in development
• Very good experience in Oracle database application development usingOracle 10g/9i/8i/x, SQL, PL/SQL, SQL Loader.
• Extensively usedMapping Variables, Mapping Parameters, and Dynamic ParameterFiles for improved performance and increased flexibility and also worked with XML Sources & Targets.
• Data Processing Experience in Designing and ImplementingData Mart applications, mainly Transformation Process using Informatica.
• Involved in massive data profiling usingIDQ (Analyst tool)prior to data staging.
• Worked with InformaticaData Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilitiesof IDQ 8.6.1.
• Developing workflows withWorklets, Event waits, Assignments, Conditional flows, Email and Command Tasksusing Workflow Manager.
• Knowledge ofpush down optimization conceptsand tuning Informatica objects for optimum execution timelines.
• CreatedUNIX shell scriptsfor Informatica post and pre session operations, database.
• Administrationand day-to-day activities like monitor network connections and database ping utilities.
• Extensive experience in implementation ofData Cleanup Procedures, Transformation, Scripts, Stored Procedures and executionof Test plans for loading the data successfully into Targets.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Experienced in handlinghuge volumes of datawith the targetdatabase.
• Expertise in the QA process of ETL mappings like Unit, Functional and Integration testing.

TECHNICAL SKILLS

Primary Tools: Informatica Power Center 9.0.1/8.6/8.1, Ab Initio (Co>Op 3.0.3.9/2.15/2.14, GDE 3.0.4/1.15/1.14 ), Teradata SQL, Teradata Tools and Utilities, Oracle 10g/9i, MS SQL Server 6.5/7.0/2000

Languages: Teradata SQL, SQL, PLSQL, C/C++

Databases: Teradata 14/13/12/V2R6.2, Oracle 10g/9i, DB2/UDB, SQL Server,MS Access 2010/2007/2003

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Linux, NCR MP-RAS UNIX

Data Modeling: Erwin, ER Studio

Scheduling tools: Control M, Autosys

TABLEAU: TableauDesktop 6/7/8/9,TableauServer 5/6/7/8/9,TableauOnline,TableauPublic,TableauReader.

SERVERS: Windows 2003, 2008, 2012R, Microsoft SQL Server 2012/2008-R 2/2008/2005.

OTHER SKILLS: Unix Scripting/Linux scripting, HTML,XML.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Agile methodology was used throughout the project and had daily scrum meeting and bi-weekly sprint planning and backlog meeting.
• Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to Testing and Implementation, Reporting etc.
• Learned the company’s EDW architecture which consists of sources, middleware, staging area, data warehouse, and reporting tools.
• Worked on data profiling & various data quality rules development usingInformatica Data Quality.
• Implemented Exception Handling Mappings by using Data Quality, data validation by usingInformatica Analyst.
• Build and developed reports based on the user stories given by the product manager and product owner.
• Held responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards inTableauthat answer key business questions
• Evaluated DataMart’s for the tableau visualization.
• Created extracts from the data source and refresh extracts on the monthly data.
• Used data blending, groups, sets, dual axis, and synchronized axis to enhance the data visualization.
• Implemented Change Data Capture usingInformatica Power Exchange 9.1.
• Designed, developedInformatica Power Center 9.5mappings to extract, transform and load the data intoOracle 11gtarget tables.
• Extensively worked on Informatica tools likesource analyzer, mapping designer, workflow manager, workflow monitor, Mapplets, Worklets and repository manager.
• UsedType 1 SCDandType 2 SCDmappings to update slowly Changing Dimension Tables
• Used Debugger inInformatica Power Center Designerto check the errors in mapping.
• Created test cases and completed unit, integration and system tests for Data warehouse.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Involved inPerformance tuningfor sources, targets, mappings, sessions and server.
• Closely moved with the Micro strategy reporting team and helped them to get the data for creating report.
• Used dashboard actions for the drill down of various reports and URL action to connect to the tableau server.
• Published reports from the tableau desktop to the tableau server and also managing the sites and projects on the tableau server.
• Creating user filters on the reports and restrict the data and the visualization based on the user requirements.
• Managed different server such as production server, Development Server and QA Server.
• Created Proof of concepts for the different user in the tableau server.
• Used JavaScript API for the deployment of the visualization in the HTML Page.
• Prepared an ETL technical document maintaining the naming standards.
• Created deployment groups in one environment for theWorkflows, Worklets, Sessions, Mappings, Source Definitions, Targetdefinitions and imported them to other environments.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.1, Informatica Data Quality (IDQ) 9.5, Informatica Analyst, Informatica MDM Multi-Domain 10.0, IDD/BDD, Oracle 11g, PL/SQL, SQL, Flat Files, TOAD, Unix, SQL Server 2012.Tableau Desktop 9, Tableau Server 9, TabCmd, IDM DB2, Data Studio 2010 UNIX script, Java, Net Beans, Oracle, SharePoint, Microsoft Excel, HTML, XML.

Confidential, NYC,NY

Data Analyst/Informatica Developer

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project coordination.
• Worked with Reporting team UsingTableau.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Expert in info graphics and Dash boarding for data visualization.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Analyzed source data and gathered requirements from the business users.
• Worked on understanding and creating ETL Design documents and specifications.
• Prepared technical specifications to develop ETL mappings to load data into various tables confirming to the business rules.
• Extensively used ETL to load data using Power Center/from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Analyzed the existing systems and made a Feasibility Study.
• Worked with various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
• Worked with Connected and Unconnected Stored Procedure for pre & post load sessions.
• Automated the processes from existing Manual processes.
• Prepared technical specification to load data into various tables in Data Marts.
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run sessions.
• Documented the complete Mappings.
• Worked extensively on Mappings, Mapplets, Sessions and Workflows.
• Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.
• Interacted with Project Manager, IT architects and SME’s to get a better understanding of the Business Processes.
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Held walk-through with team members and QA teams and communicated interface requirements.
• Responsible for validating Target data after applying different Informatica Transformations on the Source Data.
• Prepared Test Strategy and Test Plans for Unit, UAT and Performance testing.
• Coordinated and lead the end-to-end system testing effort - includes setting up the environment, code migration, running the test cycles and resolving the issues.

Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 11g, SQL, Flat files, Unix, Informatica Schedulers, Windows server, MS Access.Tableau Server 8.0, Tableau Desktop 8.0, Windows Server Standard R2

Confidential | Charlotte NC

Data Analyst/Informatica Developer

Responsibilities:

• DevelopedDesign andData Discoverydocuments for different applications in thedata maskingproject
• Worked closely withSubject Matter Experts, application ownersandend usersto get detailed working aspects of their respective apps and masking requirements
• Worked extensively onData Maskingtransformation applying all the rules available to mask data inQA/DEV/SITenvironments depending on the requirement from the SME
• Implemented various transformations likeJoiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Sequence Generator, and Router etc.
• Worked onILMto create and assign rules for data masking and generating the workflows
• Worked on different databases and flat files such asOracle, DB2, VSAM, mainframe flat files
• UsedPower Exchangeto create and maintain data maps for each file and to connect Power center to mainframe
• Worked with DBA's forperformance tuningand to get privileges on different tables in different environments.
• DevelopedMappletsand created mappings in a pipeline structureto implement reusable transformational logic
• DevelopedWorkletsto run multiple sessions
• Usedparameters and variablesat different levelslike mappings and sessions
• UsedDebuggerto fix errors in the mappings and to check the data flow
• Partitionedsessions for concurrent loading of data into the target tables
• Executed workflows usingpmcmdcommand
• Used Constraint Based Loading, partitioning, performance tuning on existing mappings
• Developed workflows withsequentialandparallel sessions
• Unit testedthe code to check if the target is loaded properly
• Migratedrepository objects, services and scripts from development to production environment
• CreatedUNIX scriptsand environment files to runbatch jobs
• Createdtechnical documentsfor end user - Instruction Manuals for the solution provided
• Provided trainingto Junior Informatica Developers on SQL and Informatica

Environment: Informatica 9.0.1, Oracle 11g, DB2, Informatica ILM, Toad for Oracle and Toad for DB2, SQL Assistant, IBM AIX, Visio, Citrix Client, Informatica Power Exchange

Confidential, Marietta, GA

Informatica/ ETL Developer

Responsibilities:

• Involved in business discussions with data modelers and business users to on the data that is to be organized.
• Re - architected data flow for performance and efficiency.
• Developed complex mappings used to using multiple Sources & Targets in different databases and flat files.
• Designed and created Informatica mappings used to build data marts according to the client requirements.
• Worked on various mappings including different transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup & Unconnected Lookup, Rank, Expression, Router, Filter, and Aggregator & Sequence Generator Transformation.
• Recommended ETL changes to improve maintainability, performance, data quality & best practices.
• Created UDF’s (User Defined Functions) to build efficient mappings using reusable functions such as lookup, sort etc.
• Created Parameter, Variables based on mappings accordingly to enhance performance.
• Worked with Dynamic Cache for better output of sessions containing Rank, Lookup, Joiner and Aggregator Transformations.
• Closely worked with the Technical Lead; Assists with data load related architecture and technical design.
• Interacted with Teradata DBA team for creation of primary and secondary indexes on data warehouse tables.
• Coordinated with the Technical Lead to develop process automation/job scheduling, Perform testing, Perform defect analysis whenever required by the Lead or the Team.
• Was also involved in the Production Support.
• Created a migration strategy to migrate Informatica Components from Dev to QA/ UAT/Production environment.
• Also participated in the documentation to describe program development, logic, coding, testing, changes & correction.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL SERVER 2005, UNIX, Toad, Access 2000, .

Confidential

ETL Developer

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs. Analyzed the source data coming from Oracle. Coordinated with Data Warehouse team in developing Relational Model.
• Created FTP connections, database connections (ODBC) for the sources and targets.
• Designed and developed mapping using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Worked on Star Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled the sessions to extract, transform and load data into warehouse database as per business requirements.
• Developed Fast Export scripts to send data files to other teams.
• Interacted with Teradata DBA team for creation of primary and secondary indexes on data warehouse tables.
• Developed Procedures and Functions in PL/SQL.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Unit Test Plans and involved in Primary Unit Testing of Mappings.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase. Involved in various meetings, seminars, presentations and group discussions.

Environment: Informatica Power Center 7.1 Workflow Manager, Workflow Monitor, Erwin, TOAD 8.6.1.0, PL/SQL, Flat files, Oracle 9i, Teradata V2R3.

Confidential

ETL Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create edit and run workflows, tasks, shell scripts.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Extensively used TOAD to analyze data and fix errors and develop.

Environment: Informatica 7.X, Oracle 9i, SQL, PL/SQL, Windows XP, 2000/2003 Server.