SUMMARY:

• 12 years of experience in leading Enterprise Data Warehousing, Data Modeling and Big Data as Project Manager Application Lead, Data Architect, BI Reporting and Data Visualization, ETL, Data warehouse Technologies, Databases and Big Data ( Hadoop Eco system, HDFS, Hive, Sqoop, PIG, Spark )
• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad - hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

TECHNICAL SKILLS:

BI ToolsData Visualization BI Analytical Tools: Cognos 10/8.x, Cognos 7.x, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Data Manager, Access Manager, Power Play, Web, Business Insight, Business Insight Advance (BIA), Business Objects BOXI R2,Tableau, Qlik view

BI Modeling Tools: Cognos Framework Manager, Transformer, Universe Designer

ETL Tools: Informatica Power Center 8.5/8.6, SQL Server Integration Services (SSIS)

Data Modeling: Erwin r7.1/7.2, ER Studio v 8.0.1, MS-Visio, IBM Rational Rose

Operating Systems: Windows (98, NT, 2000, XP, Vista, 7), UNIX, DOS

Directory Servers: LDAP server, Active Directory Server

Big Data AnalyticsData Science Tools: Hadoop, HDFS, HIVE, Spark, Hbase, Sqoop, Flume, Kafka, Cloudera manager No SQL, Hive, PIG, Big Insights, AmbariR Programming, SPSS Data Modeler & Data Mining

Languages: SQL, PL/SQL, No SQL, HIveQL

Web Servers: IIS, Apache, IBM WebSphere

Languages: C, C++, Visual Basic, C#, Java, JavaScript (Cognos SDK), XML

Databases: Oracle 11g/10g/9i/8i/7.0, DB 2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, V13 Sybase 12.x/11.x, MS Access 7.0/2000, Netezza 7.0, 9.0v, IBM Pure Data systems

Data Warehousing: Informatica Power Center 8.6.1/8.1.1/7.1.1/7.0/6.2, Power Mart 5.1.1/5.x, Informatica Power Connect, Informatica Designer, Workflow Manager, Work flow Monitor, DataMart, OLAP, OLTP, Mapplets, Transformations, Autosys, Control M, SQL*Plus, SQL*Loader, Informatica ILM TDM

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Project Manager

Responsibilities:

• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

Project Manager

Responsibilities:

• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

Project Manager

Responsibilities:

• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

Project Manager

Responsibilities:

• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

Project Manager / BI Lead

Responsibilities:

• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

Project Manager

Responsibilities:

• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

BI Project Lead

Responsibilities:

• Strong Experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Exposure in overall SDLC including Requirement Gathering, Development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management Methodologies Waterfall, Agile, MAPIT & PMAS.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings. Batch Monitoring & adhering to SLA at the contract level. Collaborating with Client based on SOW. Working on RFI and RFP.
• Experience includes vendor management, customer interaction, scope definition, project planning, capacity planning, change control and release management.
• Performing current state analysis. Connecting to all Business and Project stakeholders.
• Experience in support and enhancement based releases working with global delivery teams.
• Escalation Management team and maintaining defect log.
• Strong technical, communication, Time Management, Quality Management, Budgeting, Cost Control, and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experienced in Domains like Insurance, Banking, Retailer, Pharmacy and Entertainment.
• Working with DPEs, Run / Build Client Directors on test data management on the time lines and SLAs, status on the project plan for testing time lines.
• Experienced in leading and managing a Database and Data warehouse team of 3 to 15 people or more as part of a larger IT Development & Support teams consisting SMEs, DBAs, Database Developers and Application Developers.
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Working with senior IT and business management to develop a comprehensive data migration strategy.
• Application Portfolio Management as Portfolio lead.
• Reviewing Root Cause Analysis & Impact Analysis.
• Playing key role in the incident management.
• Managing a team of 15 offshore and onshore.
• Driving periodic demand forecast strategies.
• Application Technical Lead for Sales Reporting Warehouse team, reporting to the senior director SRW. Functional areas in scope included Area Sales, SRW, Property Sales and Account consolidation.
• Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.
• Batch Monitoring & adhering to SLA at the contract level.
• Interacting with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Analysis and data mapping for the new source systems w.r.t legacy systems.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data Marts.
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them.
• Strong technical, communication, time management and interpersonal skills.
• Highly motivated, result oriented professional with a short learning curve.
• Experience in Domains like Insurance, Banking, Retailer, Travel & Transport, Hospitality, Pharmacy, Oil and Energy and Entertainment.

ETL Application Lead

Responsibilities:

• Involved in gathering Business requirements for new models and Built models using Framework Manager.
• Updating the Framework Model when new metadata is imported.
• Created and published Packages using Framework Manager.
• Created Mix Reports with the selection criteria defaults by user role to help pre-select a subset of data that is most critical and most relevant for the users.
• Creating database connections for different data sources.
• Deploying Sample, Testing the Server and Managing Cognos Connection Portal.
• Identified facts and dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Wrote Teradata SQL queries according to process need.
• Used Teradata SQL assistant and manager for database.
• Generated reports using Teradata BTEQ.
• Creating and Managing Jobs and Schedules.
• Wrote BTEQ scripts to extract data.
• Consumed web service to retrieve user credentials from LDAP server.
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Deployed SSIS packages and scheduled jobs.
• Established loading process using MLOAD, FLOAD, and BTEQ.
• Exported data using BTEQ and fast export.
• Created Simple and Complex Reports using Report Studio with multiple Charts and Reports on 1 page.
• Introduced Highlight exceptions and graphics, and drill-down reports to expedite analysis.
• Used Query Studio for Ad-hoc Reporting.
• Created new jobs using Cognos Connection.
• Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Deploying the packages (exporting and importing the packages) using the Deployment functionality under Cognos Connection Portal.
• Wrote SQL queries to populate different calculated columns in reports.
• Training Users on Query Studio for Ad-Hoc Reporting.
• Documenting the process.

Data Analyst / ETL Developer

Responsibilities:

• Performed data analysis on all results and prepare presentations for clients.
• Performed audit on data and resolve business related issues for customer.
• Coordinated with application teams and product management team and ensure accuracy on all
• Used transformations such as source qualifier, aggregator, expression, lookup, router, filter, update strategy, joiner, transaction control and stored procedure.
• Developed and tuned Informatica mappings and Mapplets for optimum performance, dependencies and batch design.
• Worked with Informatica source analyzer, warehouse designer, transformation developer, Mapplets Designer, Mapping Designer, repository manager, workflow manager, workflow monitor, repository server and Informatica server to load data from Flat Files, legacy data.
• Designed mappings between sources (external files and databases) to operational staging targets.
• Worked with pre and post sessions, and extracted data from transaction system into staging area.
• Created SSIS packages to migrate slowly changing dimensions.
• Implemented slowly changing dimension methodology.
• Created several Informatica mappings to populate data into dimensions and fact tables.
• Maintained bugs in the bug tracker tools based on their severity.
• Analyzed and tracked test result documents and bug reports using Quality Center 9.0.
• Developed Perl script to load data from Source to Target.
• Maintained versions of mappings, Mapplets, sessions, and workflows using StarTeam/Accurev.
• Worked with the team members to identify and resolve various Informatica and other database related issues.
• Designed and developed Oracle PL/SQL procedures and UNIX Shell Scripts, data import/export and data conversions.
• Optimized Oracle SQL queries.