We provide IT Staff Augmentation Services!

Senior Contractor Resume

EXPERIENCE SUMMARY:

  • Result oriented IT professional with 11 years of overall experience and over 5 years of experience in leading and managing teams and delivering projects from inception to implementation
  • Hands on experience in multiple Informatica product suite including PowerCenter, Data Quality, Metadata Manager, Business Glossary, MDM HUB and Cloud
  • Proven track record of delivering successful projects in various business domains like legal research, health care, banking, food and home finance industries to cater to exact needs of the end users and the management
  • Excellent understanding of Business processes and Business rules and ability to maintain a strong relationship with business partners and bridge the gap between IT and business
  • Demonstrated key ability to contribute both technically and in project management / agile coaching
  • Ability to scope out the effort and cost for an enterprise solution
  • Proficient in preparing project management documentation, maintaining issue logs and making presentations to the peers and the supervisors
  • Ability and willingness to work on multiple projects and mentor resources
  • Proficient in identifying and prioritizing risks and developing action plans to cover areas of concern
  • Clear understanding of the Data warehouse Software Development Life Cycle to understand the role of every individual involved at all the stages of the project
  • Strong Knowledge of Data warehousing concepts and Dimensional modeling viz. Star schema and Snowflake schema to identify appropriate modeling techniques demanded by the project
  • Proven attention to detail and accuracy with demonstrated orientation towards rapid results
  • Hands on experience with several technologies like Informatica, SSIS, Java, PHP, Oracle, SQL server, SYBASE, MYSQL
  • Strong interpersonal and excellent written, verbal and telephonic communication skills
  • Proficient in conducting enterprise wide demos and training to pilot services and projects

TECHNICAL SKILLS:

PM Methodologies: Agile and Waterfall

DW Methodologies: Ralph Kimball and Bill Inmon

ETL ToolsInformatica: Power Center 9.x/8.x/7.x/6.x, B2B Data Exchange, IDQ, Informatica Cloud, Metadata Manager, Analyst Tool, SSIS

RDBMS: Oracle 11g/10g/9i/ 8i/7, IBM DB2, SQL server, SYBASE and MS ACCESS Web TechnologiesPHP/MYSQL, Java Scripts, and Apache Tomcat server LanguagesPL/SQL, JAVA, SQL, C/C++, FORTRAN, BBXO/SUNIX AIX, Windows NT/95/98/2000

Reporting Tools: Cognos, Business objects and Crystal Reports

Other tools: MS project, AQT, Toad, AQUA MS Visio, Erwin 4.0

PROFESSIONAL EXPERIENCES:

Confidential

Senior Contractor

Responsibilities:

  • Successfully created new dimensional schema as well as enhanced existing enterprise data model
  • Designed and developed Complex XML parsers critical for successful content conversion
  • Optimized existing workflows by performance tuning SQL queries and mappings
  • Successfully deployed internal applications to AWS using multiple options like S3, EC2, Route 53 and EMR and conducted noledge sharing sessions and demos internally and externally

Software/Tools: Informatica PowerCenter 8.x/9.x, SQL Server, Oracle, Toad Data Modeler, Visio, VersionOne, AWS, XSLT

Confidential, Minneapolis, MN

Data Management, Consultant

Responsibilities:

  • Designed and implemented Data Integration and Data Warehousing solution involving thorough analysis of multiple source systems
  • Accomplished data Integration Salesforce.com (SFDC) data into the staging, DW and DM systems for Accounts, Contacts, Contracts, Leads and Opportunities
  • Successfully delivered a solution to read and process data via Rest API calls using HTTP transformation and XML parser
  • Set up Metadata Manager (MM) and Analyst environments, user roles and permissions
  • Successfully demonstrated MDM solution by designing base, landing and staring tables
  • Created glod record for customer and product data using match and merge techniques within Informatica MDM HUB
  • Self trained on other product workbenches like Data Director, Hierarchy Manager
  • Scheduled workflows using Informatica schedulers and cron jobs to meet challenging SLAs
  • Successfully provided User Metric analysis by querying Repository tables and developing Unix scripts
  • Successfully researched MM and Analyst applications and implemented changes to modify respective UIs in order to meet extremely challenging client requirements
  • Successfully completed POC using Informatica Cloud Product to demonstrate SQL Server, Oracle, Salesforce, LinkedIn and Flat Files connectivity
  • Analyzed existing complex mappings to identify and fix performance bottlenecks to improve execution time by as much as 40%
  • Designed and implemented Data Integration and Data Warehousing solution involving thorough analysis of multiple source systems
  • Actively participated during Organizational Demos and presentations consistently
  • Worked closely with Business Analyst, Internal users, Business and Project Managers to manage the requirements and associated technical stories
  • Enhanced Multidimensional STAR schema to meet growing needs due to corporate merger

Software/Tools: Informatica PowerCenter 9.5/9/6, Informatica Metadata Manager 9.6, Informatica Analyst 9.6, Business Glossary, IDQ, SQL Server, JIRA, Salesforce.com (SFDC), Informatica Cloud, IDQ, Informatica MDM HUB

Confidential, Minneapolis, MN

Tech / Team lead

Responsibilities:

  • Successfully led a team of Six Developers on the Data Warehousing team to deliver critical WLN features and enhancements to online search teams
  • Successfully delivered complex Data Warehousing solutions using Informatica as ETL tool
  • Successfully parsed complex legal XML documents with multiple hierarchy structure to extract key information
  • Designed and developed in­house job scheduler solution using Oracle, Unix and Informatica to run jobs and meet early morning data delivery to online teams
  • Successfully provided technical leadership to design and implement a new publishing pathway to overcome difficulties faced by the users of legacy systems
  • Effectively worked with Data Orchestration and Enterprise Architects to scale up the processes and Performance
  • Effectively acted as a single point of contact to the external groups like DBA, UNIX Admins and Tech Ops to manage promotions up the environments
  • Initiated and successfully delivered best ETL practice set up efforts by closely working with higher management and Technical leadership throughout the organization
  • Shared design and approval process of test cases by closely working with QED group

Software/Tools: Informatica PowerCenter 8.x/9.x, SQL Server, Oracle, SSIS, Toad Data Modeler, Visio, B2B Data Exchange, TFS, Hadoop, Data Meer, Java, JEE, Spring

Confidential, Minneapolis, MN

Informatica Consultant

Responsibilities:

  • Successfully analyzed the requirements and designed an optimal ETL architecture and near real time solution
  • Successfully set up Informatica best practices for Confidential Grain IT department as the guidelines for future projects
  • Implemented Change Data Capture to process only new/modified records between successive runs
  • Proactively tuned ETL jobs for potential performance bottlenecks and provided efficient solution
  • Effectively carried out data discovery to help identify and fix the issues in per­development phase.
  • Worked closely with SMEs, Bas and DA to Identify and analyze risks, and recommended solutions to minimize impacts
  • Conducted training sessions and demos to ensure a smooth transition to the support team

Software/Tools: Informatica PowerCenter 8.x, SQL server, Oracle, SYBASE, Visio, Test director

Confidential, GMAC, Minneapolis, MN

Lead ETL Developer

Responsibilities:

  • Actively partnered with stakeholders in analyzing & reporting AS­IS and proposing TO­BE system
  • Scheduled workflows using Control­ M and UNIX scripts to run daily, nightly, weekly and monthly jobs
  • Identified and analyzed performance bottlenecks, and recommended solutions to minimize impacts
  • Successfully prioritized change scope and acceptance procedures
  • Lead automation of ETL processes and relieved full time primary level support resources for other organizational initiative
  • Well documented ETL specifications for a broader audience including developers, Analysts, QED and technical management

Software/Tools: Informatica PowerCenter 7.x, SQL server, Oracle, Test director, Visio, Control­M

Confidential, Saint Louis, Mo

ETL developer

Responsibilities:

  • Successfully managed cross functional, geographically diverse team responsible for ODS, Data Warehouse, Data Mart and reporting including Physical and Logical Data model
  • Started as an ETL developer and gradually worked the way up as a single point of source for multiple stakeholders and technical resources spread across the globally
  • Designed and implemented efficient ETL mappings for historical updates to save the data loading time by 40%
  • Prepared easy to grasp lower and higher level technical design documents
  • Played a major role in UAT phase of the products

Software/Tools: Informatica PowerCenter 6.x, DB2, UNIX AIX

Hire Now