Scrum Master Informatica Developer
Resume:
MS
Murugan Sundararajan
Professional Summary
Experienced technology professional having around 20 years of industry experience with demonstrated ability to quickly adapt to changing priorities based on customer needs and deadlines. Highly skilled in data warehouse modeling, analysis, design, development, testing and performance tuning of ETL & Reporting applications. More than 10 Years of Experience in Project Management and Excellent team player with strong visualization, problem solving, leadership abilities and business interactions. Proficient with all facets of project lifecycle, from discovery until maintenance and decommission. Proficient in key Scrum practices and have around 5 years of experience in performing Scrum master activities for analytics applications. Work History
Enterprise Analytics
Role: Project Management, Enterprise Reporting System, Senior BI IT Analyst
Employer: News America Marketing Wilton, CT, USA 03/2019 – Current
Project Management, Offshore and Onsite Coordination, Requirement gathering from the CEO, CFO, Senior VPs, Area Managers and other leaders of the organization. Creating Project Plan with Strategy and Approach and Detailed Risk Assessment with mitigation Plan, Work on cost estimation, resource Planning, Scheduling of Tasks and Planning the Integration of ETL and reports and planning the delivery of each phase. Work with Business Analyst on each Business requirements. Create Technical specification and work on data modelling with the architect. Manage Informatica Team, Reporting Team and get the ETL development and reports development as per the requirements. Design and create tableau Dashboards under Retailer Analytics, Digital Analytics and Media Analytics, Sales Analytics, Project Einstein Dashboards and Ad hoc Dashboards. Validate and review the deliverables with top executives like CEO, CFO and senior management team during each critical release which provides Insight into Data which help them to make informed decision during critical situations. Create and manage Additional Tableau sites for external users and work with Client Portal team regarding Embedding the Field and Artwork images in Tableau dashboards. Tableau User Management and Tableau license management. Manage AWS Key rotation, Deploy Informatica changes and tableau dashboards to all the environments thru Jenkins. Work on Ad hoc reporting tasks for the executives and management team. Coordination with vendor ********.***@*****.***
Tech/Tools/Process
• Informatica 6.x, 7.x, 8.x.9.x
• Business Objects, Cognos, Tableau,
Hyperion Essbase
• Oracle, SQL Server, AWS Redshift
• Python, Unix, SQL, Jira
DW Certifications
• Certified Informatica Developer 7
• Certified Cognos Designer 8
Education
2000 - 2002
Madras University
Chennai, India
Master of Computer Applications
1998 - 2000
Bharathiyar University
Coimbatore, India
Bachelor of Science
team members. Additionally responsible for Managing Production Support activities like Daily data reconciliation and monitor ETL jobs and Tableau refreshes. Worked on Agile methodology & Lead the Daily Scrum meetings and Perform roles of Scrum master in Enterprise Analytics application along with Project Scrum master.
CPT & Field Budget Reporting
Role: Project Management, Enterprise Reporting System, Senior BI IT Analyst
Employer: News America Marketing Wilton, CT, USA 09/2018 – 03/2019
Project Management, Project Planning, Requirement gathering from the Senior Management people like Company’s Vice Presidents, Senior Directors and Managers. Analyze the requirements and work on data modelling, create schema and tables in AWS redshift, Design Informatica Mappings and Tableau Reports. Perform Code Review. Complete the Informatica Development & the report Development with ETL team & Reporting Team. Perform Detailed Integration Testing of the Data from the Source till the Tableau Reports. Perform UAT Testing with key Stake holders. Analyze report data and provide the Insights information to the Senior management for key Decision Making. Demonstrate the reports to CEO, CFO and senior management team during each critical release. Create Tableau dashboards like Gross Profit Margin, Cost Per Tasks, Field Budget and forecasting, and Dashboards Providing Sales and Profit Analysis like Swot Analysis. Responsible for Organizational level key deliverables on time. Worked on Agile methodology & managed all Agile ceremonies with Scrum master.
ISOP and Field Analytics
Role: Project Management, Enterprise Reporting System, Senior BI IT Analyst
Employer: News America Marketing Wilton, CT, USA 12/2017 - 09/2018
Team Management and Coordination. Requirement gathering from the business People in Instore order processing and Field area managers, Data Modelling, Informatica Technical specification, Informatica Mapping and workflow creation, Scheduling, Tableau technical specification, Review and Validate the Reports developed by the Team. Tableau Dashboard creation, Tableau Dashboard Scheduling, User management, implement data level security, create python scrips for automation tasks like finding best route using google APIs. Create User specific Business object reports for field reps and scheduling the reports as per the requirements. Work on Informatica Upgrades and Tableau Upgrades. Release management thru Jenkins Jobs. Work on User acceptance testing along with Users. Resource Management, recruiting, Training and Creating resource backups. BOTx (Bridgewater front Office Transformation)
DW Team lead & Data Analyst.
Client: Bridgewater Associates Westport, CT, USA Employer: Cognizant Technology Solutions
07/2015 - 09/2017
Team Management, Recruiting, Training, Requirement Gathering, Project Plan, Test Plan, Effort Estimation, Specialized Test cases creation, Design Modular approach and create Automation Plan. Write Automation Scripts and complex Queries. Automated Module integration using PowerShell with in build Tolerance Driver. Test execution and Defect Tracking. Identify Risks and Mitigation Planning. manage the team of associates on day-to-day operations with focus on continuous improvements, automation, service enhancements and, root-cause analysis for the Issues. Additionally, responsible for BDQ reports and data Reconciliation. Enterprise Landing Zone (AML- ELZ)
Team Lead and Test Lead
Client: U.S. Bancorp Saint louis, MO, USA
Employer: Cognizant Technology Solutions
11/2014 - 06/2015
Requirement gathering, prepare technical specification document, Informatica Mapping development, Prepare Test Plan, Test Strategy and Test cases and traceability metrics. Test execution, defect tracking and management. Coordinate and manage Onshore & offshore team. Responsible for Project deliverables. Schedule meetings, sending weekly status reports. Mainly responsible for data masking the data from SORS. WB IFC – Assistant Project Manager & DW Team lead
Client: World Bank (IFC)
Employer: Cognizant Technology Solutions
03/2013 - 10/2014
Leading l4 supporting team, Work on Proposals, Research and Development, Project Planning, perform feasibility Analysis. Requirements gathering on change requests, Design, Code Review and Develop Informatica mapping and workflow, Schedule Workflows. Design and develop Tableau Dashboards. Manage support tickets and handle release activities. Perform Integration and system testing of Cognos reports during Report Migration. Engage in Through Data validation and testing of Data warehousing ETL Mappings and reports by creating appropriate test data or by efficient data sub setting. Internal Team Management, Risk Planning and Mitigation. Interview, onboard and Train new team members. Rating Reporting (RRDW) – Assistant Project Manager & DW Team lead Client: Standard and Poor’s (S&P)
Employer: Cognizant Technology Solutions
03/2010 - 03/2013
Work on Proposals, Research and Development, Project Planning, perform feasibility Analysis and work on proof of concept when and where required. Requirement gathering, Convert business requirements to technical specifications. Lead the project from requirements to delivery. Data model and database designing for new requirements. Design and develop ETL and BI solutions aligned to business requirements. Develop ETL mappings in Informatica Power Center. Coordinate with multiple stakeholders/groups for seamless project execution. Providing continuous system improvements like automation, performance improvement etc. Maintain and support existing BO reports. Provide Support to Business Objects to MicroStrategy report migration activity.
HN Analytics-Reporting Phase I – BO Reporting Lead Developer Client: Health Net, USA.
Employer: Cognizant Technology Solutions
06/2009 - 02/2010
Requirement Gathering, Analysis, Prepare the Report specification. Design and create Business objects reports related to Claims, Member-Subscriber, Provider, Billing, Commission, Pharmacy and Utilization Management as per the Requirement Document. Scheduling of reports, Unit testing, Defect fixing, deployment and support activities.
Pfizer Japan L4 (SOSC) – ETL Developer and Cognos report Developer Client: Pfizer, Japan.
Employer: Cognizant Technology Solutions
02/2008 - 05/2009
Involved in the Impact Analysis of the Champix on WARP DWH, Reports, Framework models and Cubes. Involved in data model design related to Organization structure change. Involved in designing and development of Informatica ETL mappings and Cognos Reports. Unit testing, defect fixing and support Activities. Modify existing Cognos reports impacted by the new product Champix.
DW Inception phase for DN Bi Ye – Bi Squad lead
Client: Dun & Bradstreet, USA.
Employer: Cognizant Technology Solutions
11/2007 - 01/2008
Requirement gathering and Analysis. Identify the functional test points. Estimate and prepare Test strategy and Test plan. Develop Integration and system Test cases for the Informatica Mappings. Validate the target data base objects created for the next Phase and Business objects reports. Perform Integration and System testing. Defect tracking and management. Coordinate with team members, monitor daily activities and provide the status reporting and progress report to the client and management. MIC GBF – Bi Squad Bi Squad lead
Client: Pfizer, UK
Employer: Cognizant Technology Solutions
06/2007 -11/2007
Understand the Business requirements, work on test strategy, create test cases for the Informatica mappings and workflows for both Inbound & Outbound process. Create test case for the Hyperion reports. Create requirements traceability metrics. Perform Integration and System testing by executing the test cases. Log defects and tract till its closure. Test and validate the data loading process into MIC database thru ID 16 Interface. Perform functional and performance testing of mappings and workflow scheduling and reports.
Contact this candidate