Insightful, result-driven Project Manager with proven success in building Data Warehouse, Data Mart systems and business intelligence (BI) solutions. Participated in planning, design. System analysis and implementation of solutions to support business objectives.
Excel at providing comprehensive design and full life cycle project management. Hands-on experience leading all stages of system development efforts. Including data architecture, high level requirements into detail specifications, business logic, client reporting, testing and support.
Utilizing ETL tools including MS Sql Server SSIS/SSAS/SSRS, Informatica Power Center, Power Mart, Power Exchange, Data Transformation Services (DTS), ETL package design, RDBM systems like Sybase, SQL Server 2K and DB2. Outstanding project and program leader, able to coordinate and direct all phases of project based efforts while managing, motivating, and guiding teams.
Extensive technical knowledge with leadership skills to maximize operational performance. Sybase database application developer, adept at identifying roadblocks, gap analysis, root cause investigation, used business object and crystal reporting tools, defining requirements and developing/executing technology solutions.
Extensive experience in development and maintenance of insurance, financial applications in Mainframe and Client Server environments. An asset to any organization, project and team.
Astoria Bank/Sterling National Bank 09/2015 – 11/2019
Lead Business Intelligence Data Warehouse Developer
Since merger working on Sterling National Bank FISERV InformEnt Enterprise Data Warehouse integration Initiative. Under taking the development, data requirements and enhancements of current system solutions as well as documenting the new SSIS data flow solutions. Developing 3rd Party data solutions, Supporting production environments for daily operation, resolving issue, future enhancements and implementation. Previously responsible for SQL Server 2012 DataMart/Data Warehouse and Business intelligence Initiative for the Astoria Central database. Maintain current Data Warehouse Erwin Financial Data model. Worked on all phases of data warehouse development lifecycle, from gathering FIS data requirements to design, build and develop SSIS packages, store procedures, configuration files, tables, views and functions. Create SCD dimensions in support of OLTP FIS Data Warehouse solution. Design and Build OLAP Tabular and Multi dimension model solution, Design, build conceptual Power BI reports. Implemented best practices to maintain optimal performance. Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices. Conduct code walkthroughs and review peer code and documentation. Design, build and implement Customer Master, Deposit, Loan account, Commitments, Miscellaneous, Residential, Commercial mortgages, Investments and Credit Card Systems. Point of contact for production support.
Standard & Poor’s 04/2014 – 9/2015
Responsible for all legacy Dow Jones data migration using MS BI Stack (SSIS, SSAS, SSRS) to the ORACLE production DataMart/Data Warehouse platforms to provide business user for future products development. Interface with Business Users to Collect and documenting technical data requirements, source data analysis and mapping to the target, testing, data validation, Schema design and build, creating and optimize store procedure. Create, Build and implement templates to migrate Index Divisor, Index Value, Composition, Stock Events, Stock Price, Stock Identifiers, Stock Master and FX rates data. De Normalize Dimension data to prepare for Business intelligence and analysis on target system. Single Point of contact for business and IT Offshore for any development or support issues.
DealerTrack Inc. 09/2009 – 10/2013
Lead Business Intelligence Data Warehouse Developer
Responsible for all Business Intelligence and Data Warehousing initiatives, Ensure the timely delivery of Business Intelligence solutions to the organization. Interface with Business Users, Web Sales Force Dot com, Collect and documenting technical data requirements, Schema design and build, creating and optimize store procedure, source data analysis, and mapping to the target. Contribute to all aspects of SDLC including gathering of requirements, business and technical assessments, complex back and front-end designs, implementations, testing, data validation, training and deployment. Design, Develop and build ODS, Data warehouses and production support. Build several SSAS cubes, using MS BI Stack (SSIS, SSAS, SSRS), Provide support to power users on excel, Power Pivot, Power View and tabular model. Manage an offshore and/or outsourced team. Following Business Intelligence Data warehouses projects was Managed and completed.
Current project was to design a digital retailing system (DRS) using web click data to provide business user insight for future products development. Schema design, Analyze source data, gathering of requirements, business and technical assessments, data validation, created ETL SSIS packages, store procedures, testing, implementations, training and deployment. Provided many BI reporting solutions.
Design, build, develop and Implement WINLOSS system to provide information for customer credit application submitted to the banks, ranking of approvals and declines, interest rate. Gather information from many sources, created mapping documents. Build SSAS BI solution to provide further slicing and data mining to the business users.
Design, build and develop Project Planning Management Time reporting (PPM) Data Warehousing solution. Collect data from ORACLE sources. Created SSIS process to cleanse data, store procedures. Build dimension and fact to build SSAS Cube BI solution to slice and dice for capital projects to the accounting and Project management personal.
Analyzed, design, build and develop and implemented sales territory management Data Warehousing solution using entities from CRM sales force dot com. Build slow changing dimension for these entity and fact. Created SSAS cubes, hierarchies to provide user dealer’s views of sales products, subscription, new deals and cancellation.
Migrated several data warehouses from dealertrack Portland location to New York location. Maintained and enhanced several account receivable (AR), application submissions (APPSUB), Log SSAS Business Intelligence solutions.
The Reserve 04/2008 – 10/2008
Manage a Share Holder Accounting system Database expansion project based on Agile SDLC methodology.
Analyzed over 1500 objects to define Scope and System modification Impact analysis change management release documents for the project. Document business requirements through joint work sessions, Client interviews, Survey, Data mine client complex business requirements and current system process mappings.
Develops business specifications, SQL to support these modifications. Provide several business solution recommendations to minimize system outage. Creates complex test case scenarios, SQL to test modification on different systems testing.
Management of multiple projects scope, tracking project and activity progress, tracking costs against projected spending plans, project team management, assigning high level tasks, reviewing test cases deliverables for quality assurance, and the final project management evaluation review process. Used MS-Project for controlling time estimating and scheduling Projects.
Lead team member participated in planning session of New Sybase Data Mart development project using Ralph Kimball methodology.
Data mining Fixed Income Market data feed to prepare and provide data for the Warehouse. Create current Money Market system conceptual model, entity relationship diagram and Business Flow model using UML.
JP Morgan Chase 04/2005 – 03/2008
Lead Data Warehouse Applications Developer
Responsible for Data Architecture and Strategy for OLAP projects using Inman methodology. Chair joint work sessions, document business requirements through Client interviews, Survey, Data mine client complex business requirements of New DB2, Sybase cash Flow/Revenue Data Warehouse for MIS reporting system. Data mine over 400 internal data sources, Private Banking Investment system, Foreign Exchange feeds, Equity Products Market data feed, OLAP Operational data store (ODS), OLTP Brokerage Trading & accounting system, Multi currency, Cash and Interest Rate product, DDA, MMIA, Equity Fixed Income system, Payments and other Fixed Income products, Domestic and Offshore Mutual Funds, Time Deposit. Benchmark Sybase IQ system for this project.
Enhance Current EDW entity relationship, business work flow diagrams and Data Dictionary, Logical model and apply Data Normalization process on current Dimension Model to create Star and Snowflake schema Data Warehouse. Prepare Technical Specification documents. Build presentation documents for the project. Creates complex test case scenarios to test system functionality. Monitor project workload and change management schedules. As DBA perform mapping logical to physical dimension model for cash Flow/Revenue system data warehouse, System testing, SQL Tuning of various Sybase Store Procedures. Created Sybase objects, Store Procedures and Triggers, Unix scripts, wrote Informatica Power Center ETL tool mapping build Staging Tables, BCP to load Sybase objects. Backup and recovery of test and UAT data warehouse. Setup Business Object Universe. Design many tools enabling financial decision maker to manage reporting criteria and security of the system for the highly sensitive information.
Both Project utilized Erwin, Business Object, Crystal reporting, Informatica Power Center ETL tools to manage the transformation process, Mercury QA tools for defect tracking, Transact sql, MySQL, Scripts, Korn Shell on Solaris/Unix, NDM/FTP, CONTROL-M and CA Unicenter as the Job Schedulers.
Management responsibilities include Coordinates, facilitates meetings with internal and external functional groups. Setup JAD sessions, project team, develop project plan using MS Project. Create implementation plans and change management to minimize impact on current production systems. Mobilizing the resources, activities/scope, time estimating and scheduling, on time on budget. Escalate detected project issues, risks, pit falls to the business sponsors and management. Conduct product presentations, change management, escalations, provide project release schedules and status. Managing/mentoring the day-to-day team activities, business conflicts/issues, receive and resolve all business requests.
Other project to coordinate global data center migration, elimination within Asset management and Investment banking. Responsible for Quality control of Asset and Wealth Management application, managing project onshore/offshore team and training for monitor overnight support, advice production support team on trouble shooting matters. Single Point of contact for business and IT users for any development or support issues.
JP Morgan Chase 04/2001 – 03/2005
Lead Data Warehouse Applications Developer
Responsible for Data Architecture and Strategy for current system enhancements designed & developed an OLAP Operational Data Store (ODS) in both Sybase & DB2 for several Private Banking applications. Use Erwin to create EDW entity relationship and business work flow diagram and Data Dictionary for the ODS Model. Applied Data normalization process to create ODS Dimension Model Data Warehouse. Data mining all Mainframe Legacy OLTP data sources, Private Banking Investment system, Foreign Exchange feeds, Equity Products Market data feed, OLTP Brokerage Trading & accounting system, Multi currency, Cash and Interest Rate product, DDA, MMIA, Equity Fixed Income system and other Fixed Income products, Domestic and Offshore Mutual Funds, Time Deposit, Payments and other Window NT and Unix data sources. Project utilized Prism Warehouse Executive, Informatica Power Center ETL tools to manage the transformation process, Transact sql, Scripts, Korn Shell on Solaris/Unix, NDM/FTP, CONTROL-M and CA Unicenter as the Job Schedulers. Coordinates, facilitates meetings with other functional groups and information technology for implementation plan and change management to minimize impact on current production systems. Creates complex test case scenarios to test system functionality. Monitor project work load and change management schedules.
Management responsibilities include Coordinates, facilitates meetings with internal and external functional groups. Setup JAD sessions, project team, project plan using MS Project, implementation plan and change management to minimize impact on current production systems. Mobilizing the resources, activities/scope, time estimating and scheduling, on time on budget. Escalate detected project issues, risks, pit falls to the business sponsors and management. Conduct product presentations, change management, escalations, provide project release schedules and status. Managing/mentoring the day-to-day team activities, business conflicts/issues, receive and resolve all business requests.
Work on merge data center operation and applications between JPMorgan, Chase and eliminate data centers and application. Other responsibility includes Quality control of Asset and Wealth Management application, managing project onshore/offshore team and training for monitor overnight, advice production support team on trouble shooting matters. Single Point of contact for business and IT users for any development or support issues.
Morgan Stanley Dean Witter 04/2000 - 04/2001
As a member of the Mainframe Development Environment Technical team provide support to NATURAL/ADABAS/JAVA programmers using DB2. Participate in database design, and implementation, performance tuning, optimization and day-to-day DB2/CICS/NATURAL/ADABAS/NDM application support. Heavy use of BMC software products CATALOG, CHANGE MANAGER for DB2, MAINVIEW and CICS tables to resolve application issues and implementations of DB2 objects.
Set up DB2 testing environments for SWIFT JAVA application testing. Coordinate between system Database administrator and Data Modeling group to resolve application related DB2 issues. Work on an auto Bind process for application development testing environments SYSTEST, ECHO including notification via emails.
JP Morgan 01/1995 - 08/1999
Application DB2 Database Administrator
Responsibilities included Database Administration, design, and implementation using BMC SOFTWARE, performance tuning, optimization and day-to-day Private Banking CICS/DB2 application and database support.
Maintain Legacy OMNITRUST Brokerage trading & accounting, Private Banking Investment System, DDA, MMIA, Domestic and Offshore Mutual Funds, Time Deposit and other Window NT and Unix data sources.
Responsible for creating objects on NT/SYBASE system 11 server and setting up new user groups and system security. Created and maintained multiple DB2 environments to support activity for Y2K Private Banking application. Managed team of people for Y2K testing and certification.
Participated as a Team member of ODS Data Warehouse project to analyze Private Banking Applications.
Worked on an application Re-Engineer project for Private Client group using BPWIN/ERWIN data modeling tool to document Logical/Physical Model, System business rules.
Enhanced and maintained current COBOL BATCH, VSAM, IBM MQ Series, FTP, CICS DB2 Private Banking Fund, Payments, Time deposit systems. Designed and developed Payments transfer reporting system using MS ACCESS database and EDASQL software package.
Used BMC software to create and modify DB2 objects. Wrote BMC Change Manager procedure document to implement / migrate DB2 objects from test to production, and trained other employees in the procedures.
Prosperity Break 11/2008 – 06/2009
After 15 years in the workforce I decided to pursue my dream of travelling and sightseeing. My wife and I travelled throughout India to see our friends, family and volunteering.
SYBASE System DBA Certification, 1995 and 2007
Certificate in Computer Programming - BAL/COBOL (NYU)
Bachelor of Commerce (Delhi University)