Data Manager Resume
2.00/5 (Submit Your Rating)
SUMMARY
- An Information Technology Professional with 10 years of fulltime experience in end - to-end solution delivery for large and complex projects in Big Data & Enterprise Data Warehouse (EDW), Business Intelligence (BI), Data Architecture, Analysis, Integration, Visualization, Transformation, Migration, Product development and implementation, Process and Governance
- Business oriented analysis of the systems along with data to prepare and recommend conversion solution
- Resolved data integration, support and scalability issues of a legacy policy data store system through a new efficient Data Model that reduced approximately 70% of support overhead
- Analyzed and delivered operational efficiency approximate 30% by introducing new workflow and automation to the business process
- Delivered data model for executive dashboard, single view of customer, by aggregating data from 17 countries
- Delivered Data Migration strategy for 10 years old legacy system’s data into new data model with no loss to the business
- Proven track of successful delivery of strategic enterprise level data and systems analysis that increased operational efficiency of the core business area
- Worked with and for Executives (CxO’s), Business Heads and Users, Enterprise Architects to synchronize and integrate information flow for the portfolio level initiatives
- Excellent understanding of IT landscape for large organizations in Banking, Insurance and Healthcare companies by being part of their transformation journey
- Analyzed and lead transformation of legacy core insurance system into modern era technology in record time from its pre-inception to final product
TECHNICAL SKILLS
Analytics: Visio, Erwin, Cognos FM, R-Tools, SAS EG
ETL Tools: SQL Server Integration Services (SSIS), SAS Data Integration Studio
Language: T-SQL/SQL Queries, Views, Triggers, C#, VB.NET
BI: Tableau, BI Reporting, Crystal Reports, Web Clients
Packages: Microsoft Office Suite, Microsoft Project 2010, Sharepoint, SVN, VSS, Jira
RDMBS/DB: SQL Server 2005/2008, Oracle 8i/11g, DB2,, MS Access
PROFESSIONAL EXPERIENCE
Confidential
Data Manager
Responsibilities:
- Created and managed project plan, monitor and reviewed project progress and timelines, adjusted schedules and plans as needed and identify and resolve issues to ensure project success
- Engaged closely with client and third party data providers to discover a variety of data sources available within client’s environment
- Lead the transformation of data from unstructured, disparate and decentralized to structured and harmonized through a rapid data modelling and integration process
- Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
- Lead global cross-functional team meetings and conducted timely follow-ups to track project deliverables from team
- Coordinated the effort of oracle actuarial data mart migration into Big Data Hive platform to facilitate source analysis & respective tables creations
- Coordinated the effort of mainframe site files & SAS data sets migration into Netezza platform.
Data Lead
Confidential
Responsibilities:
- Coordinated with business teams and updated the existing Data Model of APR Application while adding 100 elements & writing their respective definitions
- Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report
- Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic
- Conducted regular client meetings for ensure proper knowledge across onshore-offshore teams
- Involved in defining the source to target data mappings, business rules and data definitions.
- Responsible for defining the key identifiers for each mapping/interface
- Responsible for defining the functional requirement documents for each source to target interface
- Analyzing Project Requirements and scope definition
- Perform Smoke Functional, Integration, Performance, User acceptance testing
- Creating and executing the Test cases
- Perform Smoke Functional, Integration, Performance, User acceptance testing
- Defined the scope of assessment, the control objectives, conducted security risk assessments & internal reviews to check the compliance level
- Testing an expense management solution to take care of Travel & Employee Expenses claims
