PROFESSIONAL SUMMARY:

• Have extensive experience in Application Design, Development & Maintenance in delivering mission - critical, full life-cycle projects.
• Total Experience is 18+ years and 10+ years of experience as Technology Lead in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading ( ETL ) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta- data definitions.
• Exceptional communication and presentation skills and established track record of client interactions
• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.
• Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change effectively in rapidly evolving global business environments.
• Bagged client’s appreciation on several occasions (Identified as Ovation and Instant for outstanding performer in AML, CODIS, MIDAS and DMIS.

AREA OF FOCUS AND SPECIALIZATION INCLUDE:

• Possesses good business knowledge in Banking & Financial Services, Insurance, Health Care, Life Science, Retail, Digital Marketing, SAS Analytics and Big Data.
• Technologies worked for Teradata, Oracle, Tableau, Informatica, Oracle 10g/11g, Data Modelling & analysis, Data Architecture
• Experience of major Banking Integration, transformation and separation programs.
• Posse’s excellent communication and interpersonal skills and ability to lead team as well as program/ projects.
• Innovative in approach, enjoys learning new methods and ideas and putting them into daily practice.
• Exposure to quality processes CMM level 5 and ISO including gap analysis

TECHNICAL SKILLS:

RDBMS Tools: Oracle 8i/9i/10g/11g, Teradata 15, SQL, PL/SQL, Sybase 11.5, Microsoft SQL Server 2000/2005, Microsoft Access, Hive, HQL, AWS Redshift

Languages/Tools: Informatica 9.x, Actimize, Java, TOAD, SQL Navigator, Microsoft Visual Studio.NET, Tivoli, Chordiant, SQL * LOADER, HEAT, Putty, Adobe Campaign Management

Project Management Tools: Microsoft Office, MS Project, JIRA, Trello, LiquidPlanner, Clarity, Regulatory Reporting

Source Control Tools: SVN, Visual SourceSafe, PVCS, IBM Clear Case, MKS Source Integrity, GitHub

Design Tools: Power Designer16, Erwin, Rational Rose, UML, RUP tools and Visio

Internet Tools: IIS, JavaScript, Web Services, SharePoint 2003/2007

Testing Tools: Load Runner, Mercury Test Director and Quality Center

Reporting Tools: Tableau 10.x, Cognos, Business Objects, SQL Reporting Services, Microsoft Excel & PowerPoint

Operating System: UNIX, Windows 2008, Windows 2003, Windows XP, 2000/NT/98, DOS, Linux

PROFESSIONAL BACKGROUND:

Confidential, Philadelphia, PA

Architect/ Technical Manager

Responsibilities:

• Accurately documented ETL strategy, then captured and documented detailed design specifications for the ETL process.
• Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques. Mobilized and directed BI professionals and offshore development team of 30+.
• Managed and design data ingestion for overall 70 upstream and 40 downstream systems.
• Designed the data flow for Confidential Residential Marketing using Hive and AWS Redshift Databases.
• Designed and documented the Metadata management for the Analytics Datawarehouse
• Developed architecture standards, created supporting toolsets, provided consulting services, and matured the architecture practice via continuous process improvement
• Implemented Multi Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows, stored procedure.
• Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps and blue prints and project plans.
• Formulated and executed corporate roadmaps to ensure compliance with SOX and corporate governance criteria.
• Provided valuable input into project plans and schedules, translating business requirements into conceptual, logical and physical data models.

Confidential, Charlotte, NC

Data Architect/ Modeller

Responsibilities:

• Accurately documented ETL strategy, then captured and documented detailed design specifications for the ETL process.
• Provided valuable input into project plans and schedules, translating business requirements into conceptual, logical and physical data models.
• Mobilized and directed BI professionals and offshore development team of 30+.
• Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
• Managed status reporting, project planning, and time card approval for the onsite XDW project team.
• Manage business, customer and stakeholder’s expectation and relationship.
• Responsible for implementation & release plan and develop contingency plans.

Confidential, Columbus, Ohio

Technical Manager/ Sr. Data Modeler

Responsibilities:

• Model & Architect DW design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and SQL* Loader process and batches.
• Architect the database schema and implement dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and procedures in Teradata.
• Developed normalized Logical and Physical database models
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Architect the productivity data mart. Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10/11g.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges
• Develop strategies for use in high volume, high performance heterogeneous environment.
• Defines and captures metadata and rules associated with database designing.
• Tracks and reports project status (schedule, milestones, risks and issues) to leadership.
• Manage business, customer and stakeholder’s expectation and relationship.
• Responsible for implementation & release plan and develop contingency plans.

Confidential

Technical Lead/ Data Analyst

Responsibilities:

• Responsible for building proposal, estimates & plan for development & maintenance projects.
• Liaise with business subject matter experts in analyzing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database.
• Model & Architect DW design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and SQL* Loader process and batches.
• Architect the database schema and implement dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 11g.
• Monitor, plan, document, conduct, and evaluate assignment status with project teams and management.
• Resolves all project issues including budget, timeline, scope changes, software functionality and technology to ensure meeting business requirements and quality.

Architect/Lead - ETL & DWBI

Confidential

Responsibilities:

• Responsible for managing analysis, estimates, project plan, design, development & testing.
• Liaise with business subject matter experts in analysing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database.
• Data analysis, data cleansing, and data transformation and migration using SQL* Loader.
• Map source system data elements to target system and develop, test, and support extraction, transformation and load processes.
• Based on business rules, load health (medical prescription) related data.
• Supervised and participated in logical and physical data structures creation, determined and defined business rules for data scrubbing, transformation and data refresh frequencies.

Confidential

Project Lead/ Designer

Responsibilities:

• Manage and support development of the banks’ Global Data Warehouse (GDW) and Data Mart (DM) which sources data from the banks’ global data warehouse. Track and Monitor project tasks and report status to stake holders and leadership.
• Identify data sources (Mainframe, Oracle, SFDC), design and develop the technical/functional specification for ETL development and “the Data Warehouse (DW)” of banks’ various applications (Customer information, Mortgage account, Trade Finance, Credit Cards, Treasury etc). Generate the necessary DDLs for creating the Database Objects (Tables, Views, Stored Procedures, and Triggers).
• Responsible for designing the solution and leading a team, user, and providing system support to the customer service and warehouse groups.
• Proven success in preparing implementation plan and deployment.

Confidential

Lead Analyst

Responsibilities:

• Requirement gathering, analysis, feasibility study and estimation.
• Preparing Technical specification document and Implementation plan.
• Developing PL/SQL procedures, packages and Unix shell scripts to load the data in flat files to ODS and staging area of Data Warehouse.
• Preparing Design Document, Unit, System Test Cases and Implementation Plan.
• Worked on performance tuning of PL/SQL packages.