7+ years of IT experience in Datawarehousing and ETL Development using Informatica, Teradata, Db2, SQl, Qlikview ,BO and Unix.
Self-motivated and result driven with vision of being the best in what I do and contributing to the success of the organization that I work for.
*7+ years of IT experience in Analysis, Design, Development and Implementation with major focus on database and data warehousing applications for Banking and Finance Sector on Informatica/Teradata/DB2/MSSql/Qlikview/UNIX.
*Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
*Extensively worked on Relational and Dimensional Data modeling (Star / Snowflake models), FACT & Dimensions tables, Physical & logical data modeling, slowly changing Dimensions, Data cleansing and Data Staging of operational sources using ETL processes for data warehouses.
*Have extensively worked in developing ETL program for Data Extraction, transformations and loading using Informatica Power Center.
*Experience in implementing the complex business rules by creating transformations, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup's, Router, Rank, Joiner, Update Strategy etc.) and developing complex Mapplets and Mappings.
*Expert in implementing business rules using Teradata SQL. I have extensively worked on Teradata Utilities such as FastExport, FastLoad, MultiLoad and BTEQ to move data from UNIX/flat files to Teradata and vice versa.
*Extensive experience in creation of Extract Transform and Load (ETL) process using Teradata SQL-Stored Procedure and Informatica PowerCenter clients such as Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
*Proven experience in Data Warehousing which includes analysis of Source Systems (DB2, VSAM, Flat File, etc.), Staging area & Target systems Data.
*Proven experience in Unix Shell Scripting in different projects.
*Experience in leading the teams in delivering the code with perfection in terms of Accuracy, Reusability, Maintenance, Performance, Low Complexity and Less Inventory, achieving maximum customer satisfaction.
*Actively involved in Performance SQL Tuning, ETL tuning and Error handling.
*Experience in Developing mapping design documents for ETL process.
*Proficient in understanding business processes/requirements and translating them into technical requirements and documents.
*Experienced in Test data preparation, building test cases and execution of testing scenarios for defect-free result oriented coding.
*Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
*Efficient in following quality procedures for development and implementation.
*User facing skills and client relationship skills
Won Excellence through Leadership Award for best performance in TCS for 2nd Qtr 2011.
This is a client based quarterly award initiated by Morgan Stanley to recognize good potential in its employees, including all vendors.
This was the second time the award came to TCS.
May 2016 to August 2016
About the Project- The Account and Service Fees business and technology weighed the pros and cons of (1) enhancing the current billing systems to meet reporting / transparency needs, or (2) build an entirely new consolidated billing system.
After careful review of both the "Band-Aid" and new billing system approaches, it was decided that, strategically, it is favorable to build a new consolidated billing system, with key drivers of decision being:
Single rules-based engine in new billing system allows for more consistent exclusion logic application and business tracking / validation
New billing system removes AAA billing from Sweep
Basic billing system enhancements are expensive enough to justify entirely new, modern system more closely aligned with strategic business IT vision.
Role: Rule Analyst and Informatica developer.
Putting in place the rule approach and the rule stewardship for centralized fee hub.
Responsible for The execution of the rule management process, and helps extract and write the business rules.
Identify how rules are used in processes that implement business policies.
Ensure the quality of the business rules.
Ensure that consistent terminology is used in the business rules in order to build a common vocabulary and a domain data model.
Analyze business rules to identify conflicts, redundancies.
Ensure consistency of business rules across functions, geographies and systems.
Conduct impact analysis for revision or replacement of business rules.
Integrate new or revised rules into existing rule set.
Make recommendations for business rule changes based on business knowledge.
Facilitate resolution of business rules issues.
Act as consultant for the project team.
Conversion of applied business rules to technical requirements.
Leading the team and developing mappings to apply the business rule logic in day-to-day transactions.
Alternative InvestmentsAugust 2012 to April 2015Technical lead and Informatica Developer
About the project- Global Data Repository deals with the alternative investment funds within Morgan Stanley.
It is the standardized repository storing account, fund, transaction and fee data on day-to day basis the alternative investments like Mutual funds, Private Equity, Hedge funds etc.
The data residing in fund profile system is the master database for GDR while all the processing data resides in Db2, which is populated with the help of informatica jobs.
Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Parsed high-level design specification to simple ETL coding and mapping standards.
Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, Look up, expression, aggregator, joiner, filter, rank and router transformations etc.
Modified existing mappings for enhancements of new business requirements.
Extensively worked with both Connected and Unconnected Lookup Transformations with various lookup caches like Static Cache, Dynamic.
Responsible for Performance Tuning at the Mapping Level and session level.
Load balancing of ETL processes, database performance tuning and capacity monitoring.
Used UNIX to create Parameter files and for real time applications.
Monitoring workflows in workflow monitor and providing batch support and helped support team in fixing failures.
Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
Worked extensively with business and front-end users to understand and document business requirements and provided etl solutions.
July 2010 to July 2012Module Lead
Enterprise Data warehouse (EDW) Support and Development provides support and development of underlying data warehouse systems at Morgan Stanley to ensure operational efficiency by supporting and improving the existing systems.
This project uses business intelligence tools like Informatica for ETL suite, Business Objects & Actuate for reporting and Teradata for data warehouse.
The data marts are on DB2 and Sybase.
TCS has complete ownership to maintain, develop and enhance the system as per new user's requirements.
365 Tier 2 Support for Morgan Stanley EDW applications- Production & QA.
Analysis, Troubleshooting and Problem Resolution and Maintain documentation.
Teradata Support related activities: Sync Up, executing DML tickets, DB Space allocation.
Administer security settings.
Supporting upgrades and new releases of third party Applications Software products that are part of Supported Applications.
Maintaining supported application documentation.
Assist with development of training content and manuals for all the new joinees on the processes, technical knowledge and other business knowledge.
Manages Team with compliance to their deliverables, timesheets and appraisals and is responsible for their overall growth and development in project.
Tata Consultancy Services LtdFebruary 2010 to July 2017Designation -IT Analyst
Morgan Stanley: Morgan Stanley (NYSE:MS) is a leading global financial services firm providing investment banking, securities, wealth management and investment management services.
With offices in more than 43 countries , the Firm's employees serve clients worldwide including corporations, governments, institutions and individuals.
Wealth management EDW: Aim of this project is to set up the infrastructure for Data warehouse Application, Design the application modules and components within the proposed infrastructure framework to design and develop the application components, testing and deployment of application.
The following activities are carried out as a part of the project:.
Enterprise Database (EDB) Support and Development project is initiated to support the core load process, related ETL applications across the SILO that feed the GWM data warehouse and BI reports.
Development and testing part consists of Teradata performance tuning, ETL and BI automation.
The support activities ensure account, customer and GWM applications data are updated without any failures.
Automation of the process and creation of various reports for the application data owners ensure the status availability of the users.
Regulatory Reporting and Core processing -August 2016 till date
About the project - Regulatory Reporting involves multiple applications covering a wide range of aspects of WM banking as follows-
-Calculation of multiple parameters for Wm Securities based lending products which are required for the Regulatory Capital calculation purposes.
Credit department and Finance department are the main BUs for the application.
Creation of synopsis of Wm's foreign cash and cash equivalent financials for comparative analysis by the Fed against other similar financial entities.
Role: Onsite co-ordinator, ETL Datawarehouse specialist and Informatica team Lead.
Managing and co-ordinating around 30+ applications for ETL and distributed plant within the advisory space.
Understanding the requirement from Business and translating them into Technical requirements and creating BRDs and related documents.
Data mapping and analysis, system design and process orientation to ensure project is well-designed and compliant to audit requirements.
Mapping of data sources, movement and reconciliation.
Working alongside management and business analysts to ensure strategic data plans.
Working closely with business users of each applications and operations team to document new requirements and provide solutions.
Coordinating with offshore for ongoing project deliverables and ensuring timely and defect-free delivery.
Providing optimal solutions for performance enhancement and fine-tuning of current projects.
Tracking team tasks and deliverables for entire team, providing status to client and managing production releases of multiple applications simultaneously.
Acting as SME for all applications and representing entire team at Client Location.
Data warehouse and ETL specialist for client, users as well as offshore team by designing systems, creating learning documents and creating complex mappings/code to implement complex business logic for critical requirements.
Designing Data warehouse systems/data models for new upcoming projects and improvising existing systems to make them process oriented and in line with data growth.
Taking care of performance tuning, performance improvement and process improvement for all applications to ensure smooth operation.
Work as a release manager for full cycle of projects.
Education and Training
L.A.D CollegeWon IDEAMAX competition for best idea of process improvement in TCS
*Completed certificate course in French LanguageWon On the Spot award in category of awards for excellence.
Bachelors of Engineer: Electrical EngineeringElectrical Engineering First Class 70.87% in 2009, RTMNU, Nagpur
*Higher Secondary School Examination with distinction 82.50% in 2005, Nagpur
*Secondary School Examination with distinction 91.60% in 2003, Nagpur
Date of Birth: April 23, 1987
*Visa: H1B Visa valid till 2019
*Marital Status: Married
Banking and Financial Services
Windows XP, UNIX.
UNIX Shell Scripting
Tools and Utilities
Version controller - Synergy, Stash/GIT/Teamcity
Scheduler - Tivoli Work Scheduler
Documentation - MS-Word, MS-Excel, PowerPoint, Sharepoint.
Others - SQL Developer, Teradata SQL Assistant, Teradata View Point, IBM Data Studio, Qlikview, IT Service Desk Manager
DB2 Quest Central v3.1.1, TCM, Service manager, Servicenow
Teradata, Db2, Informatica Power Center v9.1,v.6.1, Informatica Power Exchange , UNIX, Business Objects XI3.1
Management and Leadership Skills
Extensive Business interaction and Requirements gathering.
*Date of Birth: April 23, 1987
*Visa: H1B Visa valid till 2019
*Marital Status: Married