Data Management

Sushma Harihar Enterprise Information Management Professional

E -mail - *******.******@*****.***

Phone - +1-480-***-****

SUMMARY

Seasoned design and development architect for Information/Data Management, Data warehousing, and Business Intelligence – Reporting & Analytics technologies. Sushma brings a combination of business acumen and strong technology experience to her engagements, with industry experience in the Telecommunication, Banking and financial sectors. She possesses strong experience in all phases of Project life cycle including Requirement Gathering, Analysis, Design, Development, Testing, and Debugging & Distributed Application Management support.

SKILLS

Domain

Salesforce, Investment Banking, Banking and Financial Services,

Telecommunication Services, Support Services

Development Tools

Informatica Power Center, SAP BO Data Services & Integration, SQL Loader, Actuate e.Report Designer Professional, OBIEE

DB Tools

Oracle 9i/10g/11g, SQL Server 200X, Teradata SQL Assistant

Scheduler

Appworx, Control-M, Autosys

Methodologies

SDLC – Waterfall, Agile

Configuration Management

VSS, CVS, Tortoise SVN, dbMaestro.

Operating Systems

Windows NT 4.0, Windows 2000/2003, XP, Linux, Unix

Programming Languages

SQL, PL/SQL, UNIX Shell Scripting

Testing Tools

HP Quality Centre

Utilities

SQL PLUS, SQL Developer, PL/SQL Developer, Toad, Sybase, Putty, Teradata

EMPLOYMENT DETAILS

Worked with Arrow Electronics Pvt Ltd as Senior Technical Analyst from 13th April 2015 till 27th Nov 2016.

Worked with NTT Data, Inc. as Associate Program Manager from 16th Aug 2010 to 27th March 2015.

Worked with CGI Information Systems as Software Engineer from January 17th 2007 till August 6th 2010.

PROFESSIONAL EXPERIENCE

ORGANIZATION – Arrow Electronics Pvt Ltd (Apr 2015 – Nov 2016)

Domain – Sales Force – (Apr 2015 – Nov 2016)

Contributions –

1.Designed a new ETL architecture to help process and store data in the warehouse from 4 different geographical regions in parallel– Asia Pacific, Northern America, Central America and Europe.

2.Worked with Teradata utilities like BTEQ, Fast Load, Multi Load to load data from different source systems to Terdadata.

3.Closely worked with the business leads from across the globe to provide solutions for varied requirements.

4.Designed reusable codebase that could be used across regional requirements with parameterization.

5.Worked on optimizing the ETL and Teradata code.

6.Re-modelled the warehouse to enable better performance for OBIEE reports.

7.Designed an automated reconciliation process to ensure correctness of data.

Sushma Harihar Enterprise Information Management Professional

E -mail - *******.******@*****.***

Phone - +1-480-***-****

ORGANIZATION – NTT Data (Aug 2010 – Mar 2015)

Contributions –

1.Initiated the Center of Excellence group for LBU-BI Practice

oInitiated the BI Forum, for help in troubleshooting and problem solving across engagements.

oAssisted in multiple POCs in the BI space to demonstrate feasibility of proposed solutions.

oContributed to BI Best Practices document which is the de-facto standard across projects.

oOrganized trainings.

oManaged recruitment drives.

2.Conceptualized and started team-wise Webinar/Brownbag sessions, which conducts discussions on the implementation plans adopted by different engagements and how they can be used in other projects.

3.Part of the technical team that advises on performance improvement for various applications.

PROJECTS INVOLVED

Domain – Support Services – HR, IT and Finance Responsiveness (Apr 2012 – Mar 2015)

Contributions -

Responsible for the overall design of the application as under

a.SPOC for Requirement gathering, Resource management and work allocation.

b.Suggested SDLC transition from Waterfall to Agile – this has streamlined and stabilized the project to a great extent. Also proposed usage Rally to manage and monitor work allocation and progress.

c.Data Profiling – Examined existing source system to validate adherence to Data Quality standards and for collecting statistics.

d.Data Mining - Data was mined to identify associations. Data items were then grouped according to logical relationships.

e.Data Quality – Put on my QA hat to lead discovery of data inconsistency and come up with corrections. Key points considered were - Severity of inconsistency, Incompleteness, Accuracy, Precision, Missing information.

f.Data Modelling – Re-designing Data warehouse from star schema to snowflake schema to accommodate bottom up approach on the data, maintain normalized data in dimensions, ease of maintenance and better performance.

g.Adopted Exception and bridge tables to promote reusable code and cut down the need for writing custom logic.

h.Implementation of reusable code for time period driven calculation of KPIs at various organization levels.

i.Made use of UNIX shell scripts for data sanitization at an early stage thereby reducing the cost of such corrections in downstream applications.

j.Architected batch processing for data summarization and inter-dependent data sources.

Sushma Harihar Enterprise Information Management Professional

E -mail - *******.******@*****.***

Phone - +1-480-***-****

Domain – Telecommunication Services (Jul 2011 – Mar 2012)

Contributions -

a.SPOC for Production Migration and Support, Resource management and work allocation.

b.Lead the team while taking over work from another vendor and ensured seamless transition.

c.Worked in the capacity of an Onsite and offshore coordinator.

d.Data Modelling – Re-designing of the Data warehouse to segregate the data to 2 different layers – ODC and EDW, there-by improving the performance of the reports.

e.Built scheduled processes to perform Data scrubbing.

f.Handled production issues and provided solutions within very short SLAs.

g.Was appreciated for work on complex adhoc reports written in PL/SQL.

h.Proposed usage and adoption of Quality Control tool – HP QC

Domain – Banking & Financial Services (Aug 2010 – Jun 2011)

Contributions -

a.SPOC for Requirement gathering, Resource management and work allocation.

b.Worked as an Onsite and offshore coordinator.

c.POC for migration of the system from SQL Loader to Informatica.

d.Implemented a POC using Informatica PMERR tables to capture bad data, use of parameterized information across the application for various features.

e.Built various reconciliation processes to ensure data accuracy.

ORGANIZATION – CGI Information Systems (Jan 2007 – Aug 2010)

Contributions –

a.Designed POC to demonstrate feasibility of using mapplets in mappings.

b.Practice development initiatives.

c.Key members in estimations, methodology drive for presales support.

PROJECTS INVOLVED

Domain – Investment Banking Services

Contributions –

a.SPOC for Requirement gathering, implementation, QA and Production migration.

b.Worked as a Developer and carried out various activities as per SDLC.

c.Lead and assisted the Quality Control team during the QA until successful Production Migration.

d.Developed several reports using Actuate.

e.Implemented POC using BIRT reporting tool.

EDUCATION

Bachelor of Engineering in Information Science from Visvesvaraya Technological University, Karnataka (Year 2002 - 2006).

Contact this candidate