SUMMARY

• 8 years 6 months of IT experience in teh field of Business Intelligence and Database Applications
• IBM Certified Cognos BI Solution Expert wif expertise in Cognos FM, Report Studio, Query Studio and Analysis Studio
• Excellent experience in BI/DW Architecture and Design including Requirements Gathering, Data Modeling and Design of information delivery visualization
• Experience in handling projects related to ETL tools like Talend and Informatica
• Experience in Data Modeling using Erwin
• Good experience of handling projects related to different databases like Oracle, Greenplum, Cassandra DB,HiveandVectorwise
• Has good noledge of PL/SQL codes
• Demonstrated ability to handle teh project as a Project Leadand Business Analyst
• Worked closely wif End Users, ETL developers, Data Modelers/ Architects, Report Developers and Different Functional teams
• Involved in various phases of software life cycle which includes Analysis, Design, Development and Testing
• Experienced in Project planning, scheduling, project management and execution
• Managed multiple projects running on agile methodology, teams at Onshore as well as Offshore in teh role of Business Analyst/Technical Project Lead which involves Project Management, Resource Management, Customer Management and Team Building
• End to End experience of software project right from User Stories to Final Product delivery to teh customer
• Efficiently managed teh vendor companies involved in teh projects
• Experienced in handling and managing multiple deadline driven projects
• Excellent at adapting and picking up new skills in diverse areas
• Excellent written and verbal communication in corporate environment and teh ability to perform independently as well as in team environments
• Timely appreciation by clients for teh outstanding work done
• Involved in handling POCs from client side on new technologies and providing solutions to them on migration of objects(ETL/Databases) from one technologies to another
• Trained in Tableau Reporting tool

TECHNICAL SKILLS

Reporting Tools: Cognos10, Cognos8, Impromptu, Transformer & Tableau

ETL Tools: Talend 5.4 & Informatica9.6

Database: Greenplum, Oracle, Cassandra, Hive, SQL Server & Vectorwise

DataModeling Tool: Erwin

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Solution Architect& Technical Project Lead

Responsibilities:

• Participate in meetings wif client/onsite counterpart to understand requirements and identify teh key milestones during teh project execution.
• Identify teh Source systems dat need to be migrated to DataLake i.e. Greenplum Database
• Create teh ETL Functional & Technical document
• Decide whether to create HVR job or Talend job
• Guide teh team and halp them technically to create teh Talend Job
• Prepare teh Reporting document which contains teh fields which need to be included in teh Tableau tool
• Design teh tables in teh Greenplum database
• Leading teh team to design database objects, creation of Talend Jobs & creation of Tableau report on top of it
• Testing of data loaded in Greenplum database
• Create and Run Functional Test Cases and log teh defects in Defect Management Tool
• Assist in QA, User Acceptance Testing and Production Validation
• Getting Approval From Users on teh objects which is getting migrated to Production environment
• Updating Status report on weekly follow-up calls wif teams
• Follow up wif teh technology team and teh business to ensure each steps of teh process - development/testing/adding to production are well followed through

Confidential - Atlanta, GA

Technical Project Lead

Responsibilities:

• Participate in meetings wif client/onsite counterpart to understand requirements and identify teh key milestones during teh project execution.
• Understand and prepare teh functional as well as technical document( related to Reporting, ETL & Database) as per teh business needs
• Leading teh team to design database objects, creation of Talend Jobs & creation of Tableau report on top of it
• Migration of data from relational Database to Hive & Cassandra using Sqoop
• Testing of data loaded in Cassandra & MS SQL Server so dat teh reports can be made in Tableau which is used as self -reporting tool by teh users.
• Migration of tables & Talend Jobs to QA and Production environment
• Create and Run Functional Test Cases and log teh defects in Defect Management Tool
• Assist in QA, User Acceptance Testing and Production Validation
• Getting Approval From Users on teh objects which is getting migrated to Production environment
• Updating Status report on weekly follow-up calls wif teams
• Follow up wif teh technology team and teh business to ensure each steps of teh process - development/testing/adding to production are well followed through

Confidential - Atlanta, GA

Business Analyst & Technical Project Lead

Responsibilities:

• Requirement gathering of reports as Business Analyst
• Managing teh offshore team working on Reports, database and ETL tool
• Created Functional & Technical document related to reports, ETL tool
• Designed Cognos10 package
• Technically Lead teh team to build Cognos10 & JackBe reports
• Technically Lead teh team to build Informatica Mappings
• Designed teh database tables as per teh requirement and created procedures for JackBe reports
• Tested teh reports wif Users
• Tracked teh defects raised during testing of reports in HP Quality tool
• Guided teh team to resolve teh defects wifout hampering teh timelines set for teh tasks
• Prepared teh documentation for teh QA and Production releases
• Successfully migrated reports to QA and Production
• Responsible for getting Signoff from teh users

Confidential - Atlanta, GA

Team Lead

Responsibilities:

• Designed teh ODS Database for teh PGS Portal
• Prepared teh technical documents related to Informatica ETL jobs and procedures
• Technically Lead teh team to build teh Informatica mappings to integrate multiple source systems in PGS ODS
• Created teh most complex procedures for teh PGS Portal
• Involve in testing of PGS Portal wif Users
• Tracked teh defects raised during testing in HP Quality tool
• Guided teh team to resolve teh defects wifout hampering teh timelines set for teh tasks
• Prepared teh documentation for teh QA and Production releases
• Successfully migrated database objects and ETL Jobs to QA and Production

Confidential

Team Member

Responsibilities:

• Created Cognos8 Relational package in FM
• Created Cognos8 reports in Report Studio
• Created Cognos Cubes and reports on top of it in Analysis Studio
• Prepared teh technical documents related to Informatica ETL jobs
• Created Mappings in Informatica tool
• Closely monitored teh defects raised in HP Quality Center and resolved them
• Prepared teh documentation for teh QA and Production releases
• Successfully migrated teh reports and ETL jobs to QA and Production

Confidential

Team Member

Responsibilities:

• Designed teh database objects
• Created Cognos8 Relational package in FM
• Created complex reports in Cognos8 Report Studio
• Created Cognos Cubes and reports on top of it in Analysis Studio
• Prepared teh technical documents related to Informatica ETL jobs
• Created Mappings in Informatica tool
• Closely monitored teh defects raised in HP Quality Center and resolved them
• Prepared teh documentation for teh QA and Production releases
• Successfully migrated teh reports and ETL jobs to QA and Production

Confidential

Team Member

Responsibilities:

• Designed teh database objects
• Created Complex Informatica mappings
• Cognos8 Relational package in FM
• Created complex reports in Cognos8 Report Studio
• Created Cognos Cubes and reports on top of it in Analysis Studio
• Prepared teh technical documents related to Informatica ETL jobs
• Created Mappings in Informatica tool
• Closely monitored teh defects raised in HP Quality Center and resolved them
• Prepared teh documentation for teh QA and Production releases
• Successfully migrated teh reports and ETL jobs to QA and Production

Confidential 

Team Member

Responsibilities:

• Prepare teh Mapping Documents
• Created Complex Informatica mappings
• Closely monitored teh defects raised in HP Quality Center and resolved them
• Prepared teh documentation for teh QA and Production releases
• Successfully migrated teh ETL jobs to QA and Production

Confidential 

Team Member

Responsibilities:

• Designed teh Cognos8 package in FM
• Created Complex Reports I Report Studio
• Designed teh Query Studio which used as a self-reporting tool for users
• Created Cognos Cubes and created reports on top of it in Analysis Studio
• Written javascripting to achieve teh functionality which was not possible by Cognos8 tool
• Closely monitored teh defects raised in HP Quality Center and resolved them
• Prepared teh documentation for teh QA and Production releases
• Successfully migrated teh reports and ETL jobs to QA and Production