Software Engineer Data
Resume:
Nimisha Sarma
Experience Summary
Nimisha has close to three years six months of experience in the field of information technology in the CRM space. She is currently working with Bank Of America as Senior Software Engineer. Previously she had worked with Wipro Technologies as Senior Software Engineer and Cognizant Technology Solutions as a Technical Analyst, specializing in CDI (Customer Data Integration) and MDM (Master Data Management) domain.
Her responsibilities include requirement gathering, analysis, design and implementation of applications for various clients in the field of life sciences. She has worked as Siperian Hub builder (as a configurator) and source system analyst for many projects for pharmaceutical clients. She has got training in Orchestra Network MDM tool.
Previously, she was working in Siperian 901 for providing Master Data Management Solution to Johnson&Johnson MDM upgrade project. Currently, she is working as a siperian developer and solution provider to Bank Of America. She possesses good analytical and programming skills and has excellent communication and interpersonal skills.
Highlights of Nimisha:
Thorough understanding CDI and MDM
Implementation of Siperian MRM Hub for one of the largest MDM project
Cognizant certified Siperian professional
Extensive Data Analysis experience.
Nimisha is a “Bachelor of Engineering” in Electrical engineering from Assam Engineering College, India.
Technical Skills
Operating Systems Windows 98, Windows XP
Programming Methodologies Object Oriented Methodology
Programming Languages Java, C, UNIX
MDM Tools Siperian MRM Hub Enterprise Customer Master
Tools and Utilities Informatica, TOAD, Information Analyser
RDBMS Oracle 9i(SQL/PLSQL)
Application Server Web Logic. JBOSS, Websphere
PROFESSIONAL EXPERIENCE
05Jan, 10 – Current Date Bank Of America Senior Software Engineer
21Jun, 10 – 31 Dec,10 Wipto Technologies Senior Software Engineer
17 Dec, 07 – 15 Jun, 10 Cognizant Technology Solutions, Kolkata. Technical Analyst
EDUCATION
Degree Institute/University/Board Year Marks
B.E (Electrical) Assam Engineering College 2007 70.2 %
HS Cotton College/SEBA 2003 65%
HSLC T.C.Govt. Girls School/SEBA 2001 79%
Relevant Project Experience
GSFA Conversions and MDM Design Data Solution
Industry Manufacturing
Client Pitney Bowes
Description Pitney Bowes recognizes that effective Enterprise Data Management is a strategic differentiator and a vehicle to sustained competitive advantage. High performance companies like Pfizer, Bank of America, Verizon, Staples, and D&B have out-flanked the competition by using their information as a competitive weapon. For Pitney Bowes, data enabled competitive differentiation is found through strategic business initiatives such as strategic enterprise sales and solutioning, creating more efficient and effective operational processes, and optimizing the customer experience.
The Global Sales Force Automation (GSFA) initiative has been approved and will be deploying new business processes, shared across multiple lines of business. The maximum benefit of these new business processes can only be attained when the information assets that the business creates and consumes is also considered across these lines of business. Businesses are optimized through strategic use of people, process, and information assets. As such, Pitney Bowes is taking a strategic approach to supporting the data requirements of these transformative initiatives.
EMC Consulting will provide Pitney Bowes with consulting and professional services to align their information assets to the new business processes being deployed. The goal of this engagement is to execute on the targeted data requirements of the GSFA initiative while delivering foundational enterprise data management capabilities through establishing data factory model and initial designs for Customer Master Data Management.
The outcome will be the successful delivery of enterprise data assets to support the initiatives as well as a holistic and long-term data management capability aligned to business centric goals and outcomes.
Duration Sep 2010- Current Date
Tools Used Informaion Analyser, Data Stage, Quality Stage
Responsibility Developer and Designer. Responsible for
• Data profiling using Information Analyzer.
• Generate reports in different formats and sent to SMEs for review purpose.
• Part of solution design team
Strategic Intelligence for Licensing and Competition (SILC)
Industry Life Science
Client Merck
Description Master Data is defined as the information necessary for creating and maintaining an enterprise-wide "system of record" for a business entity in order to capture business transactions and measure business results in a consistent manner.
The Strategic Intelligence for Licensing and Competition (SILC) system presents a new approach to managing competitive product information, intelligence and insight. The main component is a new database and software system for gathering, documenting and analyzing competitive intelligence.
The primary users of the SILC system will be the Merck GCI (Global Competitive Intelligence) team.
Key elements of the SILC vision are:
A) SILC will be an authoritative internal source for competitive compound and company information.
B) SILC will minimize the non-value-added work of GCI and maximize efficiency by automatically integrating the best external sources available, complemented with the value-add of our internal knowledge and analysis.
C) SILC will focus on the strategic needs of Merck and create competitive advantage to our business by enabling users to effectively and efficiently use CI.
Technology Oracle 10g
Duration Nov 2009 – Jun 2010
Tools Used Siperian MRM Hub XU SP2.
Responsibility Developer and Designer. Responsible for
• Analysis of requirements to upgrade the Customer Master in Siperian XU SP2 version
• Part of solution design team
• Configuring the application in Siperian XU SP2
• Participating in System Integration Testing and User Acceptance Testing support efforts
USHH - Customer Master Siperian MDM Hub XU SP2 Upgrade
Industry Life Science
Client Merck
Description The current Customer Master is presently running on the XS version of the Siperian Master Data Management Hub software platform. There has been a long standing effort to upgrade Siperian to the latest version XU SP2. The decision to upgrade at this time provides opportunity to:
• Evaluate, streamline and improve long running jobs
• Leverage a more reliable, efficient and maintainable match process within Siperian
• Provide a framework to eventually retire CIMS
Replace existing applications and processes with out-of-the-box Siperian tools such as BDD and External Match
Technology Oracle 10g
Duration Aug 2009 – Oct 2009
Tools Used Siperian MRM Hub XU.
Responsibility Developer and Designer. Responsible for
• Analysis of requirements to upgrade the Customer Master in Siperian XU SP2 version
• Part of solution design team
• Configuring the application in Siperian XU SP2
• Participating in System Integration Testing and User Acceptance Testing support efforts
• Participating in migration.
AZ Cornerstone Enhancements 2008 – HCOS Affiliations
Industry Life Science
Client Astrazeneca, a bio pharmaceutical company that discovers, develops, and markets Therapeutics based on advances in research and biotechnology.
Description The client wants to improve affiliations between health care professionals and accounts, and also the relationships between accounts. This will help them to support account based selling model. The improved affiliations data will provide valuable insight to various internal teams (Targeting and Performance, Touchstone reporting, etc.) such as relationships between HCP and HCA, and multi-level hierarchy between accounts. This will facilitate more accurate targeting and reporting.
The client has selected a new external vendor to provide the affiliations data and will receive a periodic feed of affiliation data. This vendor provides a knowledge base of healthcare professionals, their locations, addresses and profiles to help them gain a better understanding of professional-to-organization and organization-to-organization relationships.
It wants to integrate the new affiliations provided by the vendor with the cornerstone customer master. The objective is to integrate the affiliations data with the customer master and distribute affiliations data to various downstream applications for improved adoption into key business processes.
Technology UNIX, Oracle 10g (PL/SQL Programming).
Duration Feb 2009 – Jul 2009
Tools Used Siperian MRM XU Hub, Informatica 8.6
Responsibility • CDI Solution Developer
• Data Analysis of the possible Database structure after new Source System starts providing data.
• Requirements Analysis (business rules, data cleansing and validation rules, match rules, survivorship rules)
• Autosys job scheduling for the project.
• Configuring solution - Siperian MRM hub
• Preparing the Siperian Configuration for the project.
• Responsible for overall quality and timely delivery of all deliverables.
AZ Masterbridge Development
Industry Life Science
Client Astrazeneca, a bio pharmaceutical company that discovers, develops, and markets Therapeutics based on advances in research and biotechnology.
Description Master data consolidation and management will help AstraZeneca to improve data accuracy, overall efficiency of processes and establish solid governance.
Currently managed market master data at AstraZeneca is prepared and maintained by business. The maintenance managed market master data involves extensive manual processes. To improve accuracy and efficiency of processes and data, it is decided that the managed market data will be maintained by AstraZeneca IS organization and managed market analysts will review the data and provide feedback for modification depending on business requirements.
The key objectives of this engagement are:
• Creating an AstraZeneca Plan Master – which will encompass critical master data for Plan, Payer and PBM
• Updating the Plan Master records every month
• Generating MasterBridge file every month from Plan Master
• Generating Managed Market Exception Reports for MMAs
• Maintaining a audit trail of changes
• Validation process to capture possible data mismatch/wrong data
Technology UNIX, Oracle 10g (PL/SQL Programming).
Duration Nov 2008 – Feb 2009
Tools Used Siperian MRM Hub XU, Informatica
Responsibility • Worked as an Offshore team member in this module
• Siperian Configuration developer.
• Involved in technologies like Siperian MRM, Oracle (PL/SQL Programming), and UNIX Shell Scripting.
• Autosys job scheduling for the project.
Pfizer CCM integration
Industry Life Science
Client Pfizer, A bio pharmaceutical company that discovers, develops, and markets Therapeutics based on advances in research and biotechnology.
Description Pfizer has been maintaining customer records, gathered over several years, in disparate applications for several countries, resulting in an inconsistent view of data within the enterprise. Some of the key challenges included –
1. Data Management in silos resulting in data redundancy and Data Quality issues
2. Difficulty in Data aggregation across functions due to incompatible standards – need for manual validation, cleansing and conversion
3. Lack of 360 degree view of customers
4. Poor customer analytics
5. Losing cross-sell / up-sell opportunities
6. Poor targeting / campaign planning due to ineffective segmentation
7. Lack of customer hierarchy management
A Siperian-based CDI Hub was implemented and integrated with existing applications to provide a single view of all customers’ demographic and affiliation information, and one integrated communication strategy. This holistic view of the customer was integrated into all touch points. Key benefits achieved includes –
1. Single version of truth - enabler for enterprise application integration
2. Acting as an enabler for regulatory compliance assurance (HCP Compliance laws)
3. Avoiding resources being wasted on data reconciliation
4. Information leverage across functional areas
5. Data sourced once and reliably used
6. 360 degree view of customer facilitating customer profiling and targeting
7. Allowing diverse business user groups to natively view customer profile and sales / marketing activities data across the enterprise using real-time services in an SOA-enabled landscape
Technology Oracle 9i (SQL Programming).
Duration Jul 2008 – Oct 2008
Tools Used DQA tool, TOAD
Responsibility • Involved in Data Analysis.
External Certification
External Certified in OCA paper I and OCA paper II.
PERSONAL DETAILS
Date of birth : 09/10/1985 (MM/DD/YYYY)
Current Address : SA-5, Therndarl Flats, Valmiki Nagar, Thiruvanmiyur, Chennai-600041, India
Email ID : *****.*******@*****.***
Mobile : +919*********
Languages : English, Hindi
Contact this candidate