We provide IT Staff Augmentation Services!

Sr. Consultant Resume

FL

SUMMARY:

  • 8 + years of IT experience in software Analysis, Design, Development, Testing, Implementation and production Support of various Client/Server and Web based applications.
  • Has strong hands - on experience in ETL tool Informatica power center 6.x/7.x/8.x, Informatica cloud using salesforce.com for customer data and data modeling, data warehousing, Kimball methodologies, ETL data integration, multidomain MDM Strategies, Business Objects crystal reports and Informatica, Excellent interpersonal and mentoring skills.
  • Implemented Business Intelligence solutions in Telecom (Verizon), Financial ( Confidential ’s), Banking ( Confidential ) and Healthcare Insurance ( Confidential ) domains.
  • Hands on experience in Data modeling and Dimensional modeling using Kimball methodologies.
  • Has broad domain knowledge on Banking & Financials and Telecom.
  • Exposure to Full Lifecycle (SDLC) of Data Warehouse projects including Dimensional Data Modeling, ETL Logic & Reporting.
  • Extensive Experience in Design, Development & support of Universes & reports using Business Objects tool kit and Proficiency in implementing best practices in data warehouse and Business Intelligence, methodologies.
  • Developed numerous crystal reports using functionalities like sub reports, cross tabs, drill down, shared variables, dynamic cascading prompts
  • Has developed some ad-hoc reports using Data Providers such as BO Universe, Free-hand SQL, and Stored Procedures etc.
  • Acceptable working knowledge of ETL process with Informatica power center as ETL Tool & SQL* Loader for loading data.
  • Strong SQL development experience and Proficient in writing SQL Queries and store procedures with SQL, PL/SQL, TSQL using Oracle 9i, 10g, 11g and MS SQL Server 2005/2008.
  • Well versed with the data warehousing concepts Star schema, Snowflake star schema. Proven Technical and Business Documentation experience with large proposals. Strong time management and project coordination skills with simultaneous projects.
  • Resolved Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM
  • Created web services using informatica power center repository administration console.
  • Proficient in database design and development in SQL/PL SQL, MS SQL Server 2005/2008 R2, ERWIN, SAP BOXI Reporting, Oracle 9i and OBIEE.
  • In-depth knowledge of writing T-SQL (Transact SQL), writing complex stored procedures and provided ETL strategies, ETL Informatica modeling and scheduling tasks.
  • On daily and weekly basis involved working with business groups, regional and global team members, gathering analysis and requirements, as well as participating in the design and implementation of the firm wide reporting data warehouse.

SKILL:

Databases: MS SQL Server 2005 & 2008, Oracle 9i/10g

Languages: PL SQL, T - SQL

ETL & Reporting Tools: ETL Tools Informatica Power Center 6.x/7.x/8.x, Informatica cloud

Web Services: using administration console, Multidomain MDM ,

Business Objects: XI R2 (crystal reports ), OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, FL

Sr. Consultant

Responsibilities:

  • High Level Design (HLD) which comprises of Data Modeling, Design, Data Validation anomalies related to VPF Process, be it extracts, transfers, and/or loads right from NSTS to VPF.
  • Logical/Physical Design of the databases.
  • Details for changes in existing ETL code.
  • Details of any data validation/error checking/system testing plans/linkage testing plans required.
  • In addition to the current role also lead the ETL team of VPF Project and act as the First level Point of Contact for different users of the VPF application
  • Participating in the call of Business Requirements Designs from clients and work with Architecture/RAD team for shaping out the Design of ETL tasks lists.
  • Involved in the complete Design & Architecture of tables for ETL logic, written High Level Designs & Detail Designs for ETL mappings as per business requirements. Attending the designers call to clarify the issues in the designs to the developers
  • Ensure the work progressing to different environment as per schedule with quality by tracking the status of team members wok and consolidating the issues and help the team to understand and fix the issues
  • Data analysis and maintenance of production data
  • Hand-on in Real time integration with informatica cloud (DSS) using salesforce.com
  • Functional requirements gathering from Operational & Business Users and translate the Functional requirements to Technical requirements & specifications.
  • Creating Universes for specific reporting requirements to serve the Operational & Business Users reporting requirements.
  • Resolving issues like Loops, Fan Traps & Chasm Traps by creating Aliases and Contexts as required in removing the cyclic dependencies and testing them to ensure that correct results are retrieved.
  • Tuning the queries to improve the Performance of the existing Reports for various functional areas.
  • Implemented Row-Level Security in Universe to logically restrict data access to report user groups.
  • Created complex Yearly/Quarterly/Monthly reports using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
  • Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
  • Coordinating with the BO infrastructure team in setting up the prerequisites (TNS, DB Connectivity to BO servers) and setting up the User Groups & Users and assign appropriate privileges based on the User profile before migrating the reports & Universes to UAT & PROD environments.
  • Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to serve the reporting requirements for different locations.
  • Creating Classes, Objects and Conditions, naming and logically grouping them together as per business requirements.
  • Created universe user documentation guide for the end users reference and trained end users for generating their own ad-hoc reports including Complex reports.
  • Involved in verification and project audits.
  • Attending daily calls, Assigning & Fixing IR’s, 24/7 Production Support and 24/7 Data Support
  • Also actively involved in Project Audits, Client Presentations and Demos.
  • Hand-on in Real time integration with informatica cloud (DSS) using salesforce.com
  • Resolve Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM

Environment: Informatica power center 7.x/8.x/9.1 and Informatica cloud (DSS) with salesforce.com, UNIX, SQL Server 2005 & 2008, Business Objects XI R2, Oracle 9i/10g/11g

Confidential, NYC

Sr. Developer

Responsibilities:

  • Created various setup feeds to source daily and monthly data.
  • Developed framework for ETL workflows.
  • Created necessary RDBMS model and table structures for sourcing customer profile information based on geography, nature, asset classes and credit ratings.
  • Using Informatica Designer tools design the source definition, target definition and transformations to build mappings.
  • Created dimension and fact tables for customer per product, per profile, per region, per branch, time.
  • Designing ETL strategies for load balance, exception handling and design processes that can satisfy high data volumes. Had setup new servers and laid out a migration plan.
  • Created the workflows to receive daily and total monthly feeds.
  • Created complex Yearly/Quarterly/Monthly reports using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
  • Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
  • Coordinating with the BO infrastructure team in setting up the prerequisites (TNS, DB Connectivity to BO servers) and setting up the User Groups & Users and assign appropriate privileges based on the User profile before migrating the reports & Universes to UAT & PROD environments.
  • Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to serve the reporting requirements for different locations.
  • Creating Classes, Objects and Conditions, naming and logically grouping them together as per business requirements.
  • Performance tuning and optimization

Environment: Informatica Power center 7.x/8.x, UNIX. SQL Server 2000 & 2005, Windows 2003/XP, MS OLAP, Oracle 9i

Confidential

Campaign Developer

Responsibilities:

  • Interview with IT staff to identify the sources of data for the data warehouse, and at the highest level to identify sources of contention or metadata ambiguity which may create a problem at a later stage
  • Identification of the technical principles derived from the functional principles previously identified, and the implications of those Principles, with any obstacle and related actions identified, to remedy the constraints.
  • Created the customer tables, customer target tables according to income group, by gender, by products, by life style.
  • Created fact tables for customer per product, per profile, per region, per branch, time.
  • Created fact tables for No. of transactions per branch, per transaction type, per time.
  • Informatica Server Performance tuning.

Environment: Informatica Power center 7.x, Unix, SQL Server 2000 & 2005, SAP BO, Windows 2003/XP, MS OLAP, Oracle 9i

Confidential

ETL Developer

Responsibilities:

  • Creation of repository using Informatica Repository Manager.
  • Creation of the various transformations is implemented through Informatica Designer.
  • Configuring and Scheduling Sessions in Server Manager.
  • Configuring Informatica Server for loading of data.

Environment: Informatica Power center 6.5, Unix, SQL Server 2000 & 2005, Windows 2003/XP, MS OLAP, Oracle 9i

Hire Now