SUMMARY

• Business Intelligence/Data warehouse consultant with over 7 years of IT experience in different sectors of business such as Finance Services, Retail, Insurance and Media & Entertainment.
• Led numerous Data warehouse/Business Intelligence efforts with diverse experience playing different roles - Architect, Systems Analyst, Data Analyst and development lead.
• Experience with project management and project planning including project estimations(cost, dates, resources)
• Proficiency in DWH projects using Informatica, Teradata utilities, Microstrategy, Oracle PL /SQL and UNIX Shell Scripts.
• Expertise in defining and designing BI roadmaps & strategies and provided the solutions for large scale Data warehouse to the clients based on the suited needs.
• Experience in conducting Design Governance Meeting (DGM) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality Testing.
• Implemented the data acquisition activities with required business rules like data cleaning, scrubbing, aggregation and data merging using code-based as well as UI-based method.
• Proficiency in DWH using Informatica Power Center tool to design data conversions from wide variety of legacy systems migration like Mercator maps and from heterogeneous source system like flat files, relational databases, xml definition.
• Experience in complex transformations like Transaction Control, Java transformation, Unconnected Stored Procedures, SQL, Normalizer, Lookup, Expression, aggregator, update strategy, and execution of test plans for loading the data successfully into the target table definition.
• Deep understanding of ETL concepts, ETL loading strategy, Data archiving, Data reconciliation, ETL Error Handling, Error logging mechanism, standards and Best practices.
• Expertise with data warehousing techniques, ETL Frame work designing, data modeling and proficiency in building ETL routines to load star schema models for cases such as: slowly changing dimensions, late arriving facts, late arriving dimensions, "as is / as was" reporting, revisions to history, surrogate keys, helper tables
• Excellent Data warehouse skills - Having multiple full lifecycle project experience in developing ETL solutions as a developer, architect and leader; experience managing multiple concurrent, complex projects
• Expertise in provide viable solutions to high-volume data load scenarios with Performance Tuning methods, key range Partitioning and Pushdown Optimization in Informatica.
• Experienced in writing and presenting High level ETL design that includes source - target mapping, validations, look ups and business rules.
• Maintained the disciplined versions of Informatica objects and created the automated deployment group/labels in repository during release migration.
• Implemented ETL data reconciliation functionality and executed using pmcmd in UNIX environments.
• Good experience in Teradata utilities like BTEQ, tbuild mload, fast export and tpump.
• Experience in creation of basic Microstrategy BI reports using prompts, metrics, filters.
• Having good skill in estimations, deployment strategy, checklist, scheduling and automating the job runs.
• Experience in creating efficient and effective requirement and design documentations involving data mappings, use cases and conceptual models.
• Extensive exposure in writing Use Cases, Functional specifications, Scenarios, Business processes, Workflows, Process flows and designing the QA Methodology, Quality Strategies, Test Plans, Test Cases, Test Procedures and Test Scripts.
• Experience in coordinating with the change management groups for Clear Case Version Control and Build Making process
• Exposure to Test management tools like Mercury Test Director 7.5, Quality Center 9.0.
• Ability to learn, adapt and guide in new technologies quickly.
• A Team mentor with excellent communication, analytical, verbal and writing skills.

TECHNICAL SKILLS

Operating Systems: Windows- 98, 2K, XP, UNIX (Sun Solaris 5.x/10, Linux, AIX)

Front-End Client Tools: MS Office, MS Visio, Putty, AppWorx, control-M, TOAD 9.5, PL/SQL Developer

ETL Tools: Informatica Powercenter 7.x/ 8.6.1/9.1.0 , Data stage 7.5, PL/SQL (custom)

Databases: Oracle 8i/9i/10g, DB2, SQL Server, Teradata V2R5/12/13

Languages: C, C++, Cobol, SQL, PL/SQL, Unix Shell Scripting

BI Reporting: Microstrategy 8.x /9.2.1

Data Modeling Tools: Erwin r8

Methodologies: SDLC, Agile

PROFESSIONAL EXPERIENCE

Confidential, LA

DWBI Technical Specialist

Responsibilities:

• Managing the team day - to-day planning and problem-solving to meet deliverables and acted as Single Point of Contact in running the HEDW technical activities (shipments, returns & Pos data).
• Played the role of an architect to drive some key projects and helping define the roadmaps and BI strategy
• Provide periodic updates to the Business and Analysts on showstoppers to ensure appropriate actions are taken.
• Interacting with Business unit to understand the business requirements and provide the possible solutions.
• Develop design specifications for data integrate & to populate Data warehouse databases and data analysis.
• Design, develop, test, deploy and manage the data integration BI systems.
• Experience in complex transformations like Transaction control, Java transformation, Unconnected Stored Procedures, SQL, Normalizer, Lookup, Expression, aggregator, update strategy, and execution of test plans for loading the data successfully into the target table definition.
• Address performance issues requiring in ETL system and SQL tuning.
• Proficiency in Teradata utilities like BTEQ, tbuild mload, fast export and tpump.
• Experience in creation of basic MSTR BI reports using prompts, metrics, filters, icubes.
• Designed and developed data marts to support reporting requirements and external applications that are fed from the DW
• Tracking project activities documents like POC, HLD/LLD (RQSD), Estimates, issue log, effort log, IQA/EQA/FI logs, Test plan, test Results in QC, component & checklist, Release notes with backup plan strategy.

Environment: Windows XP, MS Office, Informatica Power Center 8.6.1/9.1.0 , Teradata 13, Unix Shell Scripting, Linux, Microstrategy 9.0.1, Teradata SQL Assistant, Putty

Confidential, NY

ETL Technical Analyst

Responsibilities:

• Involved in interacting with Business unit to understand the business requirements.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• Configured and ran the maps in Debugger mode from within the Mapping Designer to troubleshoot predesigned mapping as a part of ensuring in unit testing.
• Creating new mappings and updating the existing mappings according to the Business logic as part of change request from customer.
• Loaded Operational data from various formats of inbound Files into database Tables using Informatica and cleaned the data using appropriate business transformation rules.
• Developed UNIX shell scripts for batch execution of informatica jobs via pmcmd options and used pre/post-session commands to schedule loads and dispatch load status emails.
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions, Packages, materialized views and other database objects using PL/SQL.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
• Created users/groups and folders with assigning privileges using administrator console.
• Worked on session tuning by implementing the parallel pipeline via key range partitioning
• Involved in preparing design documents, estimates, mapping documents, Test cases/results, component list delivery note with backup plan for created mappings/jobs.
• Organized and prepared Minutes-of-meeting for daily and weekly customer’s business status call.

Environment: Windows XP, MS Office, Informatica Power Center 7.x/8.6.1, Oracle 10g with PL/SQL, Unix Shell Scripting, Solaris, PL/SQL developer, Toad, Putty.

Confidential, NJ 

Sr. ETL Analyst

Responsibilities:

• Involved in interacting with Business unit to understand the business requirements.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• Configured and ran the maps in Debugger mode from within the Mapping Designer to troubleshoot predesigned mapping as a part of ensuring in unit testing.
• Developed UNIX shell scripts for batch execution of informatica jobs via pmcmd options and used pre/post-session commands to schedule loads and dispatch load status emails.
• Helped with reconciliation of data across multiple systems.
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions, Packages, materialized views and other database objects using PL/SQL.
• Designing and Coding Stored Procedures, Functions, and Packages in PL/SQL.
• Extensive experience in using SQL* Loader and External Tables.
• Created users/groups and folders with assigning privileges using Repository Manager.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
• Worked on session tuning by implementing the parallel pipeline via key range partitioning
• Involved in preparing HLD/LLD, mapping documents, Test cases/results, delivery note with backup plan for created mappings/jobs.
• Organized and prepared Minutes-of-meeting for daily and weekly customer’s status call.

Environment: Windows XP, MS Office, Informatica Power Center 7.x/8.1.1, Oracle 10g with PL/SQL, Unix Shell Scripting, Solaris, PL/SQL developer, Toad, Putty.