SUMMARY:

• Around 3 Years of extensive experience in implementing Data Management projects involving Master data Discovery, Analysis and Profiling, Defining matching criteria for data duplication, Data governance processes
• Around 3 years of experience in Designing and Implementing ETL solutions between heterogeneous databases, rebuilding legacy applications functionality using SSIS and Oracle Database objects
• Around 3 years of experience in Implementing various Database solutions including database migrations - DB2 to SQL server, SQL server upgrades, SQL server to Oracle, data modelling, building complex queries, stored procedures, triggers in Oracle
• Strong Experience in Software Development Life Cycle SDLC including Requirements analysis, Design specifications, Code development, Code Integration, Application Maintenance, Testing and Deployment of Database Solutions.
• Strong in implementing solutions for Master data management and Reference Data management.
• Strong in Data analysis, data profiling and data consolidation needed for MDM and RDM solutions
• Hands on experience in using IBM Infosphere MDM Server V10.1 advanced edition and IBM Infosphere RDM V11.0
• Good experience in customizing MDM Initiate matching algorithm and customizing MDM server data hub, Integration of MDM data with Duns and Bradstreet D&B data
• Strong Experience in Designing and Implementing ETL solutions including heterogeneous databases and complex extraction and transformation logic
• Hands on experience in using SQL server Integration Services (SSIS) for ETL solutions
• Strong in Planning, Designing and Implementing Database migration solutions
• Strong SQL and Database experience with Databases -DB2, Oracle, and SQL Server
• Coded complex SQL queries, Stored Procedures, Triggers, Cursors, Functions and Packages in Oracle 9i, 10g and 11g, SQL server 2000, 2005
• Good knowledge of Data modelling and data warehouse concepts
• Used Rational Team Concert, Clear case and Visual source safe for version control
• Strong Problem determination, Root cause analysis and Defect resolution experience.
• Involved in Training and Mentoring of people in MDM and RDM concepts and tools.
• Has worked with off shore teams and coordinated off shore development activities.
• Experience with Waterfall, Agile and Scrum Methodologies.

TECHNICAL SKILLS:

IBM Tools: Infosphere MDM Advanced Edition V10.1, Infosphere RDM V11.0, Rational Software Architect, WebSphere Application Server 8.0, Rational Team Concert.

Language: JAVA, CGI, Scripting Languages, Markup languages, ASP / ASP.NET, Shell scripting

Others: Toad, SQL developer, SOAP UI, Autosys, Control-M, Install Shield Professional Edition, Altiris Wise Packaging Studio

OS: Linux, Unix (AIX, Solaris, HP-Unix), Z/OS, I series (AS/400), Windows XP, Windows server 2003Database: DB2, Oracle 10i,Oracle 11g, SQL Server 2005, SQL Server 2012

PROFESSIONAL EXPERIENCE:

Confidential

Technology Architect

Responsibilities:

• Gathering Requirements and getting them signed-off
• Understand existing DTS Code, SQL Server procedures, History data conditions
• Prepare design, mapping and scheduler documents for ETL/Informatica
• Design schemas, user roles privileges in Oracle environment
• Build Sql loader scripts for data migration from SQL Server to Oracle
• Migrate SQL server DDLs, code to Oracle equivalents using SQL developer migration assistant
• Rewrite and/or tune for better performance of ETL involving monthly data processing
• Define criteria for data cleansing, validations and checks that are needed as part of the data movement
• Error handling by redirecting the failed records, logging the transaction summary as part of ETL and Stored Procedure processes
• UAT, Bug fixing, Production roll-out and Support

Confidential

Technology Lead

Responsibilities:

• Gathering Requirements and getting them signed-off
• Performed data analysis, built PoCs to ensure the MDM and RDM tools capabilities
• Correlate the business to technical aspect and come up with high level design for MDM and RDM hubs customizations
• Developed medium level java customizations in MDM hub to generate unique Ids and Enrich with D&B duns, enabling webservices with user security configurations
• Developed RDM screens and field level security customizations for reference data sets
• Developed Oracle views to access MDM and RDM hub data, Modified MDM and RDM customizations related database configurations
• Designed Informatica workflows to bring in data to MDM and RDM hubs from various sources and to load data to DW from MDM and RDM hubs
• Designed Scheduling of both MDM and RDM jobs with needed dependencies and sequence
• Involved in Infrastructure setup such as MDM and RDM Installation validations, onetime Data loads, Security configurations and database configurations for various environments - DEV,SIT,UAT and PROD including DR environments
• Involved in conducting review of MDM code, ETL code, Unit test cases and results with Client QA team
• Deploying MDM code, RDM code, Database object to various environments
• Representing our change in external/internal stake-holder meetings and meetings with the release management team.
• Coordinating installation of code in Production and validating components and data
• Review, Testing, Implementations, Bug fixing during UAT, System Integration
• Was involved in training the customer on MDM and RDM products

Confidential

Technology Lead

Responsibilities:

• Assessment of existing application on AS 400 data environment
• Analyzing AS 400 RPG programs functionality using COBOL code and Autosys scheduler jobs for data dependencies
• Estimate Effort and Time for MDM adoption
• Designing Stored procedures on new platform for equivalent functionality
• Identify the new entity references corresponding to old DB2 tables in the new platform
• Work with Client SMEs in understanding the existing AS 400 application’s data architecture
• Re-design the application as per the compliance standards defined in the new platform
• Continuously interacting with client for resolving the issues and coming up with a preventive plan.
• Ensure that the best possible levels of service quality and availability are maintained according to the Service Level Agreement (SLA).

Confidential

Technology Lead

Responsibilities:

• Requirements gathering and Analysis
• Understand Confidential MDM tool architecture
• Profile the various sources data that needs to be de-duplicated and design the match criteria and scoring thresholds for the Confidential matching engine
• Design data Consolidation and Rationalization rules and work with Product vendor team to customize the MDM tool accordingly
• As part of data governance, create tasks in Confidential UI by configuring XML queries to extract the hub data that needs to be reviewed by the Data stewards
• Designing Optimal Solution for database layer and ETL layer to Extract, Transform and Load the Data using SSIS
• Generate Data consolidation reports for various data sets post MDM solution
• Build Oracle materialized views to distribute the MDM consolidated and rationalized data from MDM hub
• Define and Build Support process for maintaining MDM data hub
• Build different templates for automation of reports generation for Data governance team and for reporting Support status
• Major responsibility of spear heading the team from client location
• Review, Testing, Implementations, Bug fixing during UAT, System Integration
• Production Deployment, Support, Documentation

Confidential

ETL Lead

Responsibilities:

• Get the Functional Requirements specifications from Customer for batch process and understand the same
• High level and low level ETL flow design
• Map the entities related to sections of the paper form to the actual relational tables in the database
• Define criteria for data validations and checks that are needed as part of the data movement
• Error handling by redirecting the failed records, logging the transaction summary as part of ETL processes
• UAT, Bug fixing, Production roll-out and Support

Confidential

ETL Lead, Technical Specialist

Responsibilities:

• Interaction with Business users, Requirements gathering and Analysis
• Point person on the ETL team for other teams such as Reporting, Testing, QA and Project management for updates on status and issues
• Giving inputs and sharing knowledge with other teams
• High level and low level designing Optimal Solution to Extract, Transform and Load the Data using SSIS
• Major responsibility of spear heading the team from client location
• Played the role of a Project coordinator between various work streams within the project and create unit test and integration test plans
• Organize daily technical discussions with Onsite team also including individual offshore work stream leads and set expectations for offshore delivery
• Work with Microsoft technology team for any SSIS product related issues
• Review, Testing, Implementations, Bug fixing during UAT, System Integration
• Production Deployment, Support, Documentation

Confidential

Team Lead and developer - Database Migration including ETL

Responsibilities:

• Requirements gathering and Analysis
• Understanding existing COBOL programs logic
• Creating specifications to build the existing COBOL functionality using SSIS and Database Stored procedures in the new migrated environment
• Involved in Data Modelling and Data migration from DB2 to Oracle
• Designing Optimal Solution to Extract, Transform and Load the Data using SSIS
• Review, Testing, Implementations, Bug fixing during UAT, System Integration
• Production Deployment, Support, Documentation
• Co-ordination with the Client and On-site resources from Offshore

Confidential

Software Engineer

Responsibilities:

• Analyzing the databases given by the client.
• Migrating the databases from ACCESS 97,2K to ACCESS 2003
• Testing and doing the Quality check on the analyzed and migrated databases.
• Requirement gathering for Application packaging as Onsite Consultant
• Designing Test Cases, Packaging using Altiris Wise
• Quality assurance of Packages and deliverables
• Testing, UAT, Bug fixing and support
• Documentation