SUMMARY

• Over 10 years of experience in Information Technology across multiple domains as Scrum Master\ETL Lead\ETL Developer in Agile & SDLC (Software Development Life Cycle) process
• Certified SCRUM MASTER professional
• Good hands on experience as Scrum master reflecting strong Client Relationship Management, People Management, Project Reviews, Communication, Status/Dashboard & Metrics Reporting, Project Planning and Tracking, Onsite - Offshore co-ordination, Effort Estimation
• Highly experienced in various SDLC models, Agile, Scrum process,Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for Data Warehousing and Data Integration projects using Informatica Power Center 8.x/7.x/6.x. including Designer, Repository Manager, Server Manager, Workflow Manager and Workflow.
• Accomplished servant-leader capable of delivering Data Integration projects on time by effectively collaborating, facilitating, leading multiple Scrum teams.
• In-depth knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Technical expertise in INFORMATICA tools like Server Manager, Repository Manager, Designer Client tools, Power Center, Workflow Manager, Workflow Monitor, and Repository Manager.
• Skilled in Planning, Designing, developing and deploying Data warehouses/Data Marts.
• Worked with different data sources like Flat Files, Databases and ERPs.
• Worked with Different Databases like Oracle9i, 8i, Teradata, SQL Server 2000, DB2.
• Expert in Troubleshooting/Problem Solving skills.
• Expert in performance tuning of ETL processes.
• Extensive experience in implementing slowly changing dimensions. (Type 1, Type 2).
• Experience in UNIX Shell Scripting.
• Familiar with writing, testing and implementation of the triggers, stored procedures, functions at database level using PL/SQL.
• Adept in meeting project deadlines, based on Workloads assigned followed by process methodologies, adapting to the Standards of the client.
• Excellent team, analytical and problem solving skills.
• Good Knowledge in the area of computer forensics and electronic discovery.

TECHNICAL SKILLS

Agile Scrum: JIRA, Version one

Data Warehousing: Informatica Power Center 9.6,8.6/7.x/6.x/5.x, Power Mart 5.1/4.7, Business Objects 5.1/5.0, Oracle Warehouse Builder & SQL*Loader, Informatica Power Analyzer, Metadata Manager .

Data Modeling: ERWin 7.1.3

Databases: Oracle7.x/8.1/8i/9i, MS SQL Server, DB2, MS Access

Reporting Tools: Microstrategy, Business Objects.

Languages: C, C++, SQL, PL/SQL, Transact SQL, XML, HTML.

Scheduling Tools: Control M

Discovery Tools: Discovery Cracker, Concordance.

PROFESSIONAL EXPERIENCE

Confidential, Lewisville, TX

Scrum Master

Responsibilities:

• Scrum master for 2 scrum teams and transformed to Agile SCRUM from Waterfall
• Managed Scrum ceremonies like Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meeting
• Utilized JIRA to maintain Project dashboard, User stories, Scrum Progress, Track issues and Sprint Backlogs
• Removed team impediments on a daily basis to allow the team to deliver the sprint goals and deliverables.
• Implemented planning poker and velocity as key instruments for Release & Sprint planning
• Maintain, manage & radiate the release burn down and sprint burn down charts
• Facilitated team and cross-team Retrospectives to build good working relationships among the agile teams
• Facilitated Daily Standup meetings to ensure cross geographic sync ups across onsite and off shore
• Collaborated with Product owner in grooming and maintaining the product backlog.
• Guide the team on how to use Agile/Scrum practices
• Worked extensively with a team of analysts and trained them to attend business meetings and schedule meetings with Source System SME's for mapping purposes.
• Helped the product owners to come up with set of stories for better understanding for estimation and development.
• Actively participate in Scrum of scrums meetings to report team progress and impediments

Environment: Informatica Power Center 9.6, JIRA, Oracle 9i/8i/8.0, SQL, PL/SQL, UNIX Shell scripting, Control - M

Confidential, Lewisville, TX

ETL Developer\Scrum Developer

Responsibilities:

• Implementing SDLC of data warehousing, including requirement gathering from business users, analysis, design, creation of business requirement documents, mapping documents, development, testing and implementation.
• In corporate advanced ETL (Extract Transform and Load) and data warehousing concepts for large data volumes using informatica ETL tool
• Work with line of business users and business analysts to understand and capture data requirements
• Worked with DSA team to build efficient data models for better design
• Provided software solutions utilizing Oracle/SQL server databases efficiently through SQL/PLSQL and efficient utilization of UNIX shell scripting with advanced Informatica concepts for key design
• Worked with Quality Analysis teams and users to detect, fix and retest and document any defects in the code
• Worked with the offshore team and lead the offshore by coordinating day to day activities for better on time project deliverables
• Worked on different source systems like XML, RDBMS & Flatfiles
• Worked on scheduling tools like Control - M and Informatica Schedulers. Work on different source

Environment: Informatica Power Center 9.6, Oracle 9i/8i/8.0, SQL, PL/SQL, UNIX Shell scripting, Control - M

Confidential

ETL Developer/ETL Lead

Responsibilities:

• Maintain major warehouses like Financials, Supply Chain and Human Resources.
• Designed and developed several ETL scripts using Informatica, Unix shell scripts.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Developed and modified Unix shell scripts to reset and run Informatica workflows using pmcmd on Unix Environment. Conversant with the Informatica API calls.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Created users in Informatica, assigned them various permissions.
• Backup/Restoration of repositories.
• Upgrade of repositories when upgrading to new versions of Informatica.
• Created various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer.
• Created workflows and tasks in Workflow Manager and linked the database through server setup and various other connections.
• Completed various data load simulations to stress test the mappings.
• Involved in monitoring Informatica jobs/processes using Workflow Monitor.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length, and target based commit interval.
• Extensively worked on Unix Shell Scripting, Using pmcmd to automate the process by Autosys on UNIX environment.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.

Environment: Informatica Power Center 7.1.x, 8.5.1, Oracle 9i and 10g, MS SQL Server 2005 PL/SQL, SQL*Loader, SQL Navigator 5.5, Unix, Linux, Windows XP.

Confidential, Franklin, TN

Informatica Developer

Responsibilities:

• Extensively involved with business clients and users for requirement analysis and to define business and functional specifications.
• Understanding the Client’s system, preparing the Application Document for the above applications which includes all the technologies that have been used, about the project and the Production Support Documents and rewrite of this application.
• Created Source to Target Matrix Documents, Mapping Design Documents and Workflow Design documents
• Worked in Informatica 8.6 for the ETL from various sources to the central data warehouse.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Used Informatica Designer to create mappings, mapplets and reusable transformations.
• Changed the existing tables in to TYPE II dimension.
• Scheduling daily status meetings with the Off-shore team to discuss project updates within the team and individually.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.
• Developed reusable transformations and Mapplets to use in multiple mappings.
• Involved in Unit Testing of the mappings.
• Ensured the Data Marts Loads Run On Time and Accurately.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad, Erwin and UNIX

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Interacted with business representatives and users for requirement analysis and to define business and functional specifications.
• Interacted with end-users, business analysts and external vendor to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Extensively used ETL tool Informatica Power Center to extract data from heterogeneous source systems and send the data to the external vendor in XML format.
• Designed and developed transformation rules (business rules) to create ETL mappings using Informatica.
• Extensively used Changed Data Capture (CDC) approach efficiently to capture only the changes.
• Extensively developed mappings for error handling approach and also to capture ETL Metadata.
• Created reusable transformations and mapplets and used them in mappings.
• Worked extensively on XML files as sources and targets.
• Extensively worked with Tasks, Sessions, Workflow and Implemented Performance issues in Mappings and Workflows.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load, update Processes and Batch Processes Scheduled Sessions and Batches.
• Tuned Mappings and Workflows for better Performance.
• Involved in helping the Data Modeler in Data Modeling using Embarcadero ER /Studio.
• Involved in helping the reporting team using tool Informatica Power Analyzer.
• Extensively helped the testing team in testing of the Informatica maps.

Environment: Oracle 8i, SQL Server7.0, Erwin, Informatica Powercenter, MS Access 2000UNIX and Windows NT/2000.

Confidential

Dispute Associate

Responsibilities:

• Planning and leading electronic discovery projects.
• Advanced training w/ a variety of computer forensic and electronic discovery software, including Discovery Cracker, Attenex, Ringtail, Concordance, Encase, and FTK.
• Experience and training in MS-SQL and MS-Access.
• Developing and maintaining documentation and quality control measures.
• Hosting and review support for attorneys, including searching, tagging and generating report.

Environment: Discovery Cracker 4.8, Attenex, Concordance 7.8, SQL Server.