SUMMARY

• I am an experienced Senior Associate with great amount of technical skills and a passion for resolving complex problems at ease. Adept at maintaining focus on achieving the right end results while formulating and implementing advanced technology and business solutions to meet a diversity of business needs. I possess excellent analytical, interpersonal and communication skills with strong desire for innovation.
• 10+ yrs. professional experience with the design, development, implementation and maintenance of databases and software systems with Fortune 500 companies.
• Over 5+ years of experience in Logical and Physical Data Modeling, Enterprise Data Warehouse Design, Operational Data store Design, DataMart Design using Star/Snowflake Schema, Slowly Changing and confirmed Dimensions, Fact and Dimensional tables. Experienced in using Erwin tool.
• Managed various BI Acceleration tracks - Informatica Metadata Manager, Informatica Push Down Optimization, Informatica Data Quality Analyst, Informatica Data Validation Option
• Proven ETL Architecture experience involves defining different layers like landing/staging, recovery point layers and complete ETL schedule and flow to fit SLA, mapping design, Error handling and Workflow Design on Informatica Power Center 9x.
• Strong working exposure and detailed level expertise on both Agile and Waterfall methodologies of project execution
• Interacted with various business communities to capture, verify, prioritize and finalize business requirements
• Expertise in Database/ETL Load Performance Management and solutions related to Data quality & security, Meta data management
• Proficient in developing and maintaining various PLSQL/Database objects like packages, functions, stored procedures, triggers, tables, Views, Materialized views, Indexes, Sequences, partitions.
• Strong analytical and interpersonal skills, Excellent in customer management, relationship building with exposure of working in multi-cultural environments
• Performed SQL tuning, DB performance enhancement tasks for the performance and speed of execution of database objects and performed dynamic SQL embedding and execution.
• Experience in performance tuning and SQL optimization using (Hints, Explain Plan, Auto Trace, and TKPROF).
• Experience in Teradata data base and tools like BTEQ,MLOAD,FLOAD,TPUMP
• Proficient in restructuring tables, de-normalization of tables and building Materialized views.
• Work closely with stakeholders (Reporting team, Analysts and Business) and source system domain experts.
• Data Modelling with ERWIN and Power designer tool.
• Domain experience include Banking and Financial Services -- Retail banking, Asset Management and Private Banking, Supply Chain Management -- Manufacturing, Order Management, production planning

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Sr Data Engineer/Data Modeler

Responsibilities:

• Dynamically conducting interactive Joint Application Development (JAD) sessions with business users for gathering, Business Rules definition, Business data modeling and implemented cost effective and efficient design solutions
• Acquired business knowledge in this domain and built understanding of user requirements and expressed them to a granularity that makes each user story - independent, estimable, buildable, testable within a sprint timeframe
• Delivery of complex system requirement by proper logical and physical data models using ERWIN tool.
• Teradata Impact Assessment and Capacity Planning.
• Improved business operational efficiency by creating data marts to provide integrated view of operational data the building dashboards and adhoc reports using OBIEE.
• Taken the responsibility of analyzing the source system and ETL Process Design and Data Extraction from Oracle ERP to the Warehouse.
• Managed and groomed developers. Work Delegation and conducted effective code reviews, System testing documentation.
• Effectively handled offshore coordination and product owners to have a clear understanding on requirements and delivery of the system to be. Demonstrated ability to see patterns, identify root causes and combine disparate ideas to maximize value.
• Highly focused on efficiency and process improvement.

Environment: Teradata 14, Informatica 9, Erwin, UNIX, Croncale v9 and OBIEE

Confidential, Boston, MA

Sr ETL Lead / Data Modeler

Responsibilities:

• Adopted to Agile development best practices and proactively offered improvements to the agile process.
• Actively involved in the data modelling and design of the data warehouse with Senior Data Modeler, Designed and Implemented star schema models, Identified and built Facts, Dimensions, Aggregate tables to support the reporting needs and requirements of the users.
• Accountable to physical design Teradata tables, views, Stored Procedure, load scripts. Responsible for Extracting, Transforming and Loading data from Oracle source applications and placing it into Data warehouse using Informatica ETL Tool.
• Achieved performance improvement in database, through explain plan, analyzed and modified indexes and modified queries with derived or temporary tables to improve the performance.
• Mentored software engineers in design and coding best practices in individual and group
• Settings. Performed effective code reviews and supervised junior developers.
• Designed and implemented error handling frame work for current project.

Environment: Oracle 10g, TERADATA 13, Informatica 9, Power Designer, UNIX, Autosys and OBIEE

Confidential

Senior BI/ETL Developer

Responsibilities:

• Participated in requirements analysis and gathering as an analyst alongside with the core team in private banking.
• Developed ETL modules and built reporting solutions.
• Worked on documenting the technical specifications, and database design along with the technical architects.
• Tested modules based on the test cases created for each module and integrated system

Environment: Oracle 10g, Abinitio, Java, Webserver, Erwin, UNIX, Autosys and Oracle Discoverer

Confidential

BI/ETL developer

Responsibilities:

• Design and development of CDC process
• Worked with heterogeneous sources including relational sources and flat files
• Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic. Tuned the application to meet performance requirements.
• Unit and Integration testing of OWB mappings.
• Developed daily schedules for jobs to be run on Autosys considering various job dependencies.
• Provided production support for both the modules. Environment: Oracle 10g, PL/SQL, Oracle Warehouse Builder, Oracle Discoverer, UNIX, Perl

Environment: Oracle 9i, Oracle Warehouse Builder, PL/SQL, Erwin, UNIX, Autosys and Oracle Discoverer

TECHNICAL SKILLS

Data warehousing: Dimensional Modeling - Star, Snowflake, Facts and Dimensions, Slowly Changing Dimensions, OLAP (Worked on Both Kimball and Inmon Approach)

ETL Tools: Informatica Power Center 9x

Data Modeling Tools: Erwin 9.3 and Power Designer

Source Control Tools: Visual Source Safe, Rational Clear case, Subversion Control

Databases: Oracle 8.x/9.x/10g, Teradata 14, Big Data

Reporting and Analytical Tool: Oracle Discover 6i and OBIEE 11g

Meta Data Management Products: Informatica 9x

Query Languages: SQL, PL/SQL

Scripting Languages: UNIX shell scripting, Perl