SUMMARY:

• Over last 18 years I worked under various capacities covering multiple roles where I gathered experience in IT and Business initiatives where projects were delivered on schedule and successfully accomplished the given goals. The main areas of such under various roles are highlighted below. My industry domain experience touches the following sectors: Finance, Insurance, Retail and Distribution, Manufacturing, Healthcare, Pharma and Govt. Agencies.
• Some of the key experiences under various roles and responsibilities are highlighted below:
• Participate in business projects based on IT expertise. Responsible for all aspects of people leadership for the Business IT Expert team. Setting expectations, coaching, counseling, developing, evaluating, feedback, hiring, discipline and separation. Financial implications of the IT projects and management along with delivery ranging up to $ 10 MM. Ability to assess the overall needs of various clients and strategize the needs based on business processes and tools needed for solution.
• Business Process:
• Identifying and implementing best practices and strategic solutions through process & system analysis along with technology investments and the road maps handling new or modified business process to bring in efficiency. Proactively identifies areas of opportunity to apply IT for new business opportunities, process improvement, and cost efficiencies. Provides insight to the business stakeholders on how to best develop and leverage IT capabilities for the organization. Provides consulting and recommendations to managers, supervisors, and the workforce on the implementation of quality and process improvement initiatives.
• Business Analysis:
• Assesses business information needs and identify system requirements which includes evaluation of business intelligence data and reports with analytics needed to answer business questions. The role will facilitate and drive strategy around data architecture, teams, stewardship, quality, master data management, statistical practices and insights, overall data lifecycle management and creating market differentiating opportunities. Overseeing the data vision, planning, priorities, budgeting and execution of various data program initiatives across the organization.
• Data Warehousing and Business Intelligence:
• Experience in data warehouse/business intelligence covering areas of Data Warehouse best practices Experience in data modeling, meta data management and data integration best practices along with tools. Developing and also leading large teams onshore and off shore for data models - relational, dimensional, subject areas, and business models Experience with Data Lakes and provisioning various datasets for quantitative analysis and providing guidance to business community to leverage data lakes. Experience in handling large data sets for Data cleansing, Data lineage and Data standardization across enterprise covering multiple countries.
• Project Management:
• Manage projects assigned to the team, including cost, schedule, and technical performance for all deliverables with quality controls in place. Build relationships with stakeholders, manage and report the status of all projects and technical activities, and work with IT stakeholders and implementation partners (including vendors) responsible for designing and developing solutions based on best practice.
• Special Skills:
• Implementation experience of ERP solutions covering areas in Finance, Retail and Distribution, Shop Floor for Manufacturing. Regulatory requirements like Dodd Frank, Basel II and III with experience in General Ledger Reconciliations.
• General Skills:
• Excellent interpersonal skills and capable to build relations across organizations including IT executives, stakeholders and external vendors. People management skills and capability to identify strength and weakness of team members and leverage from their strength and mentor on their weakness.

TECHNICAL SKILLS:

Cloud: IBM Watson Analytics / IBM InfoSphere DataStage / Microsoft Azure with Polybase using Visual Studio with Hadoop, Map Reduce Capabilities/ Microsoft Power BI

Databases: Microsoft SQL Server / Oracle / AWS Redshift

Analytics: Cognos / Business Objects / Micro Strategy on Cloud / Tableau / Qlik View / Microsoft SSRS / Microsoft SSAS / Axiom / Oracle OBIEE

ETL and Data Modelling Tools: Informatica on Cloud / Data Stage / Microsoft SSIS / Ewrin Data Modeler / Erwin CloudCore / Power Designer

Appliances: Neetezza / Microsoft PDW / SAP Hana / Teradata

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. Consultant

Responsibilities:

• Establish and maintain a business relationship between IT and Finance departments, providing the organization appropriate and effective technology solution opportunities. Partner with appropriate IT groups, business and outside vendors to ensure effective management of the company’s technology assets.
• Define and maintain strategies, processes, and procedures through collaboration with other technology teams. Worked closely with technology team in translating "pre-cloud" logical infrastructure architecture into cloud provider-specific architecture with PoC’s with AWS and Azure taking into account requirements, constraints, costs and available features and capability matrix provided by vendors.
• The matrix includes Compute resource, Storage and Data requirement, Network Requirement and Security Requirement Worked with SMA’s from Amazon and Microsoft for solution offerings with architect to cover current business and new business opportunities and prepare proposals around it. Worked with IT internal resources to understand the impact on changes for process with data feeds and data processing (on premises and on private cloud ) keeping cost and efficient with improvements. Scenarios of SaaS with Informatica Cloud and Micro Strategy Cloud where impact analysis were done in terms of efforts needed for code modifications and deployment from on premise to cloud efforts.

Environment: Microsoft Products / Cloud Micro Strategy / Informatica Metadata Management and Informatica Data Quality/ Business Objects / AWS S3 / AWS Redshift / AWS EMR

Confidential, New Jersey

Sr. Solution Architect

Responsibilities:

• A project to understand the current landscape and recommending future landscape with complete blueprint for a warehouse solution and analytical solution. Responsible to understand the current Business Processes focusing in the areas of data warehousing / BI. Working with senior executives to lay down a 10 year road map which will cover all business expansions and was involved with IT team for feasibility study.
• Ensuring alignment of cross program IT strategy and planning with company's business goals. In the process interviewing various stake holders understanding their current and future needs. Providing guidance as to how things can be made better with business processes, data flows and the architecture to handle such volume and data needs in a single technology platform with a warehouse / mart which can be a plug and play without significant IT costs going forward. Which is currently with multiple technology stacks and business processes giving operations issues. Also providing solutions with in-house data and unstructured date from cloud (big data) in context with architectures for product compositions and customer feedbacks from social media. Develops a long-term strategic utilization plan for the company's IT systems and helps “as is” architectures become “to be” architectures through phasing and cost benefit analysis. Which leads to talking to vendors and other IT solutions providers shortlisting to develop on agile methodology to accomplish proof of concepts.

Environment: Microsoft Suite of Products including Azure and Polybase with Power BI, JD Edwards, SAP, SAP BW, Micro Strategy, Erwin

Confidential, New Jersey

Sr. Data Architect / Project Manager

Responsibilities:

• Responsible to integrate various commercial loan lending systems to centralized warehouse. Where different business units could leverage single true version of data for various needs. Focused also on government regulatory requirements like Dodd Frank with M’s, Q’s and A’s schedule extracts for compiling regulators needs. Managed an offshore team to develop centralized warehouse from multiple sources (over 8 major commercial systems). Understanding CFO level needs for Financial Operational data and Management Reporting needs. Ensuring the availability of data in structured and unstructured (cloud) for enhanced projections and forecasting needs. Collaborated with external consultants like Confidential for direction to set up milestones covering management initiatives and regulatory deadlines and coordinating with offshore development teams and ensuring standards and deliveries were on time. Mitigating risk factors with various unaligned datasets from various sources. Building warehouse data extract capabilities to handle other lines of business for the bank covering Retail and Commercial Loans, ATM’s, Risk Management, New Product possibilities with forecasted data from enterprise and cloud data extracts. Using AWS / Cloudera to integrate and architect various schedules which needs public data feeds from various financial institutions and government bodies. Extracting compliance related data from Big Data environment in Hadoop. Very good understand of Hadoop and Map Reduce architecture with clusters and node formations to process data for regional data integrations. Good understanding of Govt. PDF files and architecting the same to store in Big Data Hadoop environment which gets used for Dodd Frank and Basel Stress test reporting.
• Participated Data Governance Program with regulators to ensure data accuracy and completeness before entering the Enterprise Warehouse.
• Collaborated with senior members of CFO, Regulators and Treasury to design and roll out a state-of- the-art Master Data and Management Solution. Resolved the issue of inconsistent and inaccurate data being used for Finance and Regulatory Reporting.
• Establish data governance practices and implemented a Data Governance Dashboard for data profiling, life cycle management and metadata management.
• Designed and implemented a user maintained rules engine allowing real time rules entry for data quality analysis, data transformation, remediation and threshold management of all liquidity classes.
• Converging 8 commercial loan systems into Axiom for Monthly, Quarterly and Yearly FRY reports for IHC covering various schedules.

Environment: Erwin / Power Designer / DB2 / SQL Server / Teradata Financial Service Logical Data Model (FSLDM) / Office 2012 with Power Pivot and Power View / MS Project 2010 / Visio

Confidential, Austin, TX

Solution Architect

Responsibilities:

• Responsible to streamline various Data Warehousing initiatives which focuses in consolidation of various source systems from feeds coming across enterprise covering multiple country operations. The program involves getting various data feeds from multiple sources and loading them to a data mart which includes staging, data mart and semantic layers data formation to tackle various business questions. This extends further ad hoc reporting, as if scenarios and predictive analytics giving the end user self-service BI experience with minimum dependency on IT. The scope extended to integrate new big data sets from internet click streams and social media into a relational structure which further merged with in-house various databases for enhanced analytics. Good architectural knowledge of Hadoop and Map Reduce processes to load and retrieve data to RDBMS structures. Some experience with Pig syntax to pull data from Hadoop Big Data Environment.
• Further responsible to ensure industry’s best practices and methodologies which covers various areas of Business Process Documentation, Data Modeling, ETL Loads, Business Layers and Data Security. Actively involved with team members giving inputs to Project Manager in the areas or risk management with pro and cons with various approaches and also being mentor to other team members. Lead architect for integration several source systems which comes in from various source systems capturing media campaigns, impressions, CPC etc.
• Accountable to build a general health check and data integrity for centralized data warehouse which brings data from over 2,300 flat files and csv files on a daily basis from all over the world from various agencies. Daily incremental data goes Confidential few gigabytes. This covers operational controls and check along with reporting / audit compliance controls performing various routine checks. A dashboard which provides high level data and also drill down capabilities where there are discrepancies. Designed in such a way so that the models can be deployed with any other data source integration with minimum customizations.

Environment: SQL Server 2012 &2008 / PDW Appliance V1 &V2 / Micro Strategy / Office 2012 with Power Pivot and Power View / MS Project 2010 / Visio

Confidential, Deptford, NJ

Project Manager / Senior Architect Lead

Responsibilities:

• Responsible to spearhead this initiative to address critical business areas like Productivity, Inventory, Finance and Billing. The responsibility covered Project Management with few resources, re-engineering of some critical business processes along with building new data warehouse / marts. For the 1st time self service
• Business Intelligence capabilities were introduces using SQL Server 2012 and Power View and MDX Cubes which reduced maintenance cost significantly and enhanced more capabilities for end users. Also worked on unstructured data around medications along with their side effects from blogs. Integrating unstructured data with internal RDBMS structures for enhanced analytics. Ensuring various cross systems data lineage and data management with various controls in place with multiple systems of record.

Environment: SQL Server 2005 / SQL Server 2008 / SQL Server 2012/ Office 2012 with Power Pivot and Power View / SharePoint 2012/ MS Project 2010

Confidential, Philadelphia, PA

Global Project Lead for Enterprise Data Warehouse Architecture

Responsibilities:

• Confidential operates over 92 countries with over 500 difference applications and on variety of data stores. The goal was bring some of the key business units under a single and true version of datasets (MDM) which could be used for management reporting and executive dashboards and be a centralized feed for all source systems.
• Was responsible to run this program with a team of 40 outsourced consultants and build a centralized data repository which had data governance and stewardship in place. The 1st phase was to build Master and Data Management for Customers across enterprise. I was also responsible to review and approve designs and model for many source systems which needed Business Process Re-Engineering along with data models, business rules for MDM which was fed to the warehouse. Preparing various project plans to accomplish these alterations and ensure timely and successful delivery within budgets. The program was for $4 million with projection of $25 million for 4 year initiative.

Environment: SQL Server (multiple versions), Oracle (9i and 10i), IBM Netezza, IBMInfoSphereMaster Data Management, Cognos Enterprise with TM1, IBM BigInsight Text Analytics and IBM BigSheets, Multiple versions of SQL Server SSRS and SSAS across enterprise, Office 2010, 2012 and SharePoint 2010, Clarity, Case Wise.

Confidential, New York, NY

Project Manager / Sr. Enterprise Data Warehouse Architect

Responsibilities:

• Loan IQ a syndicate financing application which was used by all loan processing business units of Confidential globally (over 400 branches) had its own sub General Ledger. The goal was to consolidate the General Ledgers at corporate level which would eliminate lot of manual process and man-power globally.
• Had a team of 20 people with skill sets of Business Analysts, Data Model Architects, ETL and Report Developers. The massive initiative needed several business process flow adjustments, building data models and several technical documentations which were articulated through ETL processes to feed centralized
• Data Marts used for corporate level reporting. Streamline reporting tool sets to single technology at enterprise level ie: Business Object XI R3 saved the enterprise huge licensing cost, resources and IT maintenance which accounted over $1 Million a year. Worked in areas of Data Management practice, ownership with domain data governance with Metadata Management and Data Quality.

Environment: SQL Server 2008, Oracle 9i, Loan IQ 6.0, Informatica 8.6, Business Objects XI R3, IBM Cognos 8.2/10 (DataNet), MS Project 2010

Confidential, New York, NY

Project Director & Sr. Enterprise Data Warehouse ArchitectZ

Responsibilities:

• It’s one of the largest hedge fund company operations globally. The demand and challenge was to be able to absorb 3td party data from various sources and formats (worldwide) which enabled traders for more effective and accurate business decisions in their respective stock exchanges. Being global with multiple time zones the complexity was to process the 3rd party data feed correctly and load it to a centralized warehouse for dashboards and ad hoc reports.
• Was leading the entire initiative with pool of 25 plus people (both offshore and local). Was the chief architect to decide how the data should be massaged, cleansed and loaded from over 150 sources on a daily basis twice a day. The biggest challenge was how to reduce processing time and get data available globally. Designed 5 data centers which had real time replication of data using Informatica Data Replication and IBM Netezza with capability to tackle large volume and speed, which gave significant improvement in performance over network worldwide. Managed a project plan of $5 million with combination of strategic and maintenance projects. Implemented and managed cross divisional Informational Data Governance with data management policies & routines with audit and correction processes with Data Quality and Stewardship. Implemented data quality design standards and best practices with SDLC implementation Steering Committee covering various PMO processes to include Data Quality and Compliance definitions.

Environment: Oracle 8i, 9i, IBM Netezza 100, SQL Server 2005, 2008, Informatica, Office Suites, IBM Cognos Suites, SAP