SUMMARY:

• Strong lead experience in application design, business analysis, data design, development, architecture and full life cycle of applications.
• Excellent business domain Experience in HealthCare, Supply Chain Management (Procurement), Sales, Planning, Finance/ Insurance, Pricing, Hedge Funds, Stocks/ Securities, Trading, Reinsurance, Accounting, Telecom, Retail and Manufacturing Business Domain.
• Leader in Scrum/Agile and Waterfall methods.

EXPERT IN:

Data Warehouse/ Data Mart, Big Data/Data Lake / Data Reservoir, UDA (United Data Architecture), Corporate Information Factory (CIF), Enterprise Data Hub, Operational BI., Database Administration ( Oracle 11g/10g), TERADATA 14.10/ 15.10 , Cloudera HADOOP 5, Impala, Hive, HDFS, Python, Ab Initio 1.14.28/ 3.0.2 , Enterprise Meta Environment(EME), Informatica Power Center 9.5, Designer 9.5, Repository Manager 9.5, Workflow Manager 9.5, Workflow Monitor 9.5, Informatica Power Center Administration, Web Based Administration Console, DataStage 9.0, Data Stage Designer, DataStage Director, Information Analyzer, Data Modeling (conceptual, logical and physical), Dimensional Modeling, Meta Data Repository, Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Decision Support, Data Mining, Database Design, Data Analysis and Designing using UML Object Modeling, XML, Production Support, Erwin 8, Power Designer, Visio, Performance Tuning, ETL, Staging Area, Migration from Legacy, PowerConnect ( Striva Detail ) for Mainframe, ESP, AutoSys, UNIX Shell Scripts, SPL, SQL, T - SQL, PL/SQL, Stored Procedures and ASPECT Call Center Data Mart and ECS Server under UNIX, Linux and Windows. Master data management ( MDM ) solutions and meta data management experience. Hands on experience in OLAP, OLTP and Mainframe.

EXPERIENCE:

Confidential, Bloomfield, CT

Lead Data -Solution Architect / Technical Lead

Responsibilities:

• Participating in development of Cloudera Hadoop Data Lake Environment and data ingestion, using Scoop, Impala and Hive. Scripting in Scoop and in HIVE for loading data into Data Lake. Designing and building out the tables/ Views in HIVE for supporting data analytics.
• Worked on IMPALA for building out the tables for supporting reporting from data lake.
• Worked on HDFS environment for data validations using tools like Hue and Toad etc.
• Familiar on using Python and HDFS commands. Worked on Scoop and HIVE on complex batch and ETL data pipe lines etc. Experience on data load to Hive and Impala tables.
• In-depth knowledge / experience on Hadoop and HDFS architecture and Map Reduce.
• Reading data from HDFS using SAS and R and designing aggregation layer in Impala for reporting.
• Participated Spark and Kafka streaming design for integrating real time feed into data lake, from sources like Confidential websites. Integrated Relational and Unstructured data into lake for analysis.
• Designing the model for new Teradata Warehouse. Designing and developing the ETL environment for Teradata Insight Data Store. Providing solutions for business problems and designing the ETL for loading data into new warehouse. Automating TPT, Fastload and Multiload scripts and other etl processes using ESP scheduler. Performance Tuning Teradata environment using proper Primary indexes for data distribution and applying indexes and using partitions etc. using views point etc.
• Analyzing data and coming with solutions and data designs for supporting different analytic applications, working with business stake holders on blue print walkthrough’s and remediation.
• Developing, testing and rolling out the agile processes into Teradata environment.
• Designing the required infrastructure for the application, to meet the committed services level.
• Designing and fine tuning the Semantic Layer for analytical dashboard and drill through requirements. Supporting web applications and working with senior management on forecasting application status etc.
• Developing Security infrastructure for Teradata Environment.
• Leading the development processes on an agile environment and providing the suitable solution for business problems. Rolling out the code into prod environment supporting SLA’s etc.
• Supporting the reports and dashboard development on Tableau, Looker, SAS and on Cognos and fine tuning applications. Researching data quality issues and recommending solutions.
• Attending Scrum meetings and providing input to scrum masters on solutions. Educating new hires and recommending best practices for the development.
• Working on POC’s, designed data masking solutions, worked on data and application security etc.
• Supporting Dashboard and reports developments in Tableau and in Looker.
• Working with business partners and optimizing the data and reporting designs.
• Performance Tuning ETL and Semantic Layer for BI and analytics.

Environment: Cloudera Hadoop 5, Hive, Impala, Pig, hdfs, python, Oracle 11g, Teradata 15.10, Query Grid 2.0, TPT, Mload, Fastload, Sas, AIX unix, Linux, unix scripts, informatica power center 9.5, Data Stage 9.0, Tableau, Looker, Esp scheduler, Cirro, View point, Erwin 8, Sybase, SQL Server, DB2 etc.

Confidential, Bloomfield, CT

Lead ETL/Solution Architect /Technical Lead

Responsibilities:

• Designing the required infrastructure for the application, to meet the committed services level.
• Participating in the business meetings to gather the requirements and data needs.
• Participating in the design of conceptual and logical data model for different subject areas.
• Working with downstream and upstream system owners to understand the data and different inbound and outbound feeds.
• Designing proper security for the production data access to make sure HIPAA and IIPI rules are strictly followed and applied in it.
• Participating in defining different project scopes, high level from an Architecture perspective
• Creating blue prints, architectural artifacts and holding walk through’s with business and senior management.
• Involved in tools selection and Proof of Concepts for different requirements.
• Designing ETL Design and architecture for the CCDR and providing the vision to the ETL development team towards reusability for ETL components towards implementing the Service Oriented Architecture.
• Designing and data feeds for different Data Marts for reporting applications to work on.
• Working with Business Users and gathering requirements for Dashboards/ Score Card and Cognos Cubes etc. Designing the metrics and related objects in the data marts to support the business questions. Working with reporting team in designing the reports etc.
• Ensuring 24X7 availability of data and application.
• ETL code development and supporting different project UAT’s.
• Designing and developing the application for data marts for reporting environment.
• Participating in POC for TERADATA Implementation.
• Participating in POC for HADOOP for building out Data Lake environment.

Environment: Oracle 11.g on a RAC environment. DataStage 9.0, Informatica 9.5, Data Stage 9.0, Erwin 8, ESP(CA Workload Automation), IBM Tiwoli Workload Manager, DB2, SQL Server 2014, Sybase, Access, SAS, Visio, Cognos, Visual Studio etc.

Confidential, New Britain, CT

Data Lead / ETL Solution Architect

Responsibilities:

• Supporting broad, efficient global rollouts with rapid user and supplier adoption and integration of multiple legacy systems and capture of all spend.
• Facilitate faster, more effective communication, compliance and collaboration with multiple stakeholder’s worldwide. Participate in the development of procurement strategies, policies and integration of systems across product lines, Identifying cultural and other business issues.
• Expediting buyer-supplier communications, through trend analysis, to achieve shorter cycle times through a single shared architecture for the warehouse.
• Leveraging best practices to build procurement consistency and improve effectiveness of the warehouse. Supporting rapid implementation via flexible and extendable architecture, with scalability and performance
• Leading the Implementation of Ariba Spend Management Solutions, and standards based such as UNSPSC and spend visibility at invoice line item level ( SKU) for the enterprise to gain control and improved visibility into entire procurement lifecycle, through integration of multiple source legacy and ERP systems. The integrated source systems include SAP, and packaged Products like BPCS. The SAP source system modules includes accounts receivable, payable, budgeting and analysis and Supply chain management applications ( sales performance management, purchasing, inventory management and forecasting and multi-code manufacturing applications like production scheduling, capacity planning and plant maintenance.
• Developing metrics for measuring Supplier performance ( price, delivery, quality, service etc. ) and requisition, PO, Receipt or invoice transaction volume. Multiple Currency and Language support.
• Analyzing the Data and business requirements and creating the Project plan, and measuring the progress of the project in different milestones, and resolving any discrepancies in the life cycle.
• Working with business customers ( stakeholders) worldwide in the requirements gathering and performing the data analysis and designing the architecture / application for different projects.
• Designing the data flow diagrams and developing the Conceptual, logical and physical data model for different subject areas like sales, planning, and procurement. Designing the overall process flow for the applications and co-coordinating with stakeholders, and getting the business approval.
• Providing the target to source data mapping documents ( specification) to the ETL development team, and ensuring the projects are executed and delivered on time. Providing code to the ETL developers for the development. Validating the data in the UAT environment and Coordinating different testing phases and production rollouts between business and IT.
• Investigating / researching different production problems, and working with the business and IT in resolving them on a timely manner.
• Developing XML based, standard extract format for integrating the data, across different source systems and for the re-usability of ETL design / code.
• Designing the data model for different subject areas using Power Designer.
• Analyzing the ETL process flow and ensuring the best practices are followed in the design and development.
• Dependency analysis and participating in the identification and design of Local and Shared Containers towards reusability, input to standardizing business rules and code development.
• Developing the EDW shared infrastructure to support rapid acquisitions within a reasonable timeframe.
• Working with the Reports development technical team in the design and development of Business Object Universe, Coordinating the deployment of reports and dashboards between business and IT.

Environment: MS SQL Server 2012 and 2008, TSQL, SSAS, Query Analyzer, Enterprise Manager, Sybase PowerDesigner 12.5, IBM Information Server, Data Stage 7.5 and Websphere DataStage 8, DataStage administrator, DataStage Designer, Director and DataStage Manager, XML, XML Spy, Business Objects Enterprise XI Release 2, Business Objects Planning, SAP, SAP BW, BPCS(Business Planning and Control System - by System Software Associates) .

Confidential, Hartford, CT

Senior Teradata & ETL Solution Architect

Responsibilities:

• Assist project teams in Blueprints, Holding design walkthroughs.Assist in performance measurement and monitoring of production Teradata environment. Define and develop performance-tuning measurements for the large in size Teradata database. Define infrastructure and application standards and approaches - hardware, software and methodology
• Provide input into logical and physical design of all subject areas of Warehouse.
• Design proper architecture for Regulatory / and compliance reporting requirements.
• Designing the data integration flow and diagrams / road maps, to use XML, from rapidly changing SOA web based source systems. Analyzing different types of XML documents ( free form, DTD, XML Schema etc.) to find the entity references and relationships, to use in the data design.
• Physical implementation of warehouse structures including tables, indexes, PI, PPI, compression etc.
• Design of the ETL processes and design of data warehouse control infrastructure
• Design of new warehouse subject areas including individualization and house-holding
• Developing Disaster/Recovery and security methodology for Warehouse
• Warehouse performance management, monitoring and resource management
• Design, architect and implement common components for use across multiple applications
• Providing setup and support of different data analysis applications to Technical system analysts team
• Design responsibility for control infrastructure and derived data sets built from detailed data.
• Promote adherence to published standards and MI guidelines, best practices
• Designing an appropriate Data Mart strategy for the EDW, promoting MI culture/ infrastructure across different lines of business
• Providing insight to EDW Teradata Amp and Node Server farms.
• Defining development environment strategy, and setting testing guidelines. Designing disaster/recovery strategy for EDW.
• Coordinating vendor product evaluations and assist in vendor product rollouts and understanding its impacts in the MI, Supporting new product developments and implementations ( speed to market ).
• Participating in host and distributed version meetings to understand its impacts on the EDW/BI environments.
• Designing re-usable ETL components to be useful across different data domains and lines of business
• Designing and developing a Service Oriented Architecture (SOA) for the EDW applications space.
• Supporting rapidly changing product offerings and ensuring company business vision/ strategy is supported by different MI applications. Designing Conceptual, Logical and Physical data models for different projects.
• Participate in creating a road map for EDW towards Teradata Active Data Warehousing to support rapid decision-making real time.
• Supporting Microsoft Analysis Services, Cubes and Cognos, impromptu BI environments.
• And making sure the KPI’s are reported in a timely manner in the BI environment to support effective decision-making
• Designing high level ETL architecture for different Warehouse projects. Working with Vendors in the development, testing and production rollouts of applications.
• Developing processes for ACCORD XML transactions, to conform to the industry standard.

Environment: Teradata, Ab initio 1.14.28, Enterprise Meta Environment(EME), Data Profiler 1.7.5.1., Fastload, Multiload, TPump, Parallel Transporter, Unix, Erwin 7.1, Teradata Administrator, Microsoft Analysis Services, MDX, Cognos Powerplay, Impromptu, DB2, Sql Server 2005, XML, Accord, XML spy

Confidential, Stamford, CT

Tech Lead - ETL

Responsibilities:

• Experience on fund instruments /strategies like equities, derivatives, swaps, fixed income, cds, convertibles, Corporate actions, dividends and foreign currency exchange etc. Knowledge on options, futures and short selling.
• Developing processes for reconciling daily trading activities in stock exchanges in USA and U.K.
• Reconciling the cash and position levels between executing brokers, Prime Brokers and fund managers on different Portfolio’s. Experience on pricing calculations for P&L on different tickers using details from Bloomberg and Sedol etc.
• Analyzing the data and database, and designing and developing the data model and architecture for different Processes.
• Designing and developing the ETL frame work and processes using Informatica 8.0, to run on the Domain, Integration Services and Nodes, on a Highly Available Confidential . Excellent hands on knowledge on Integration Services and Load Balancing using Powercenter 8.0. Developing T-Sql routines in Sybase and Sql Server.
• Experience on data sources like XML, Pdf files, excel, relational and mainframe files.
• Performance tuning the ETL processes, to use the Informatica Push Down optimization, in the staging and source databases, thus maximizing the flexibility and providing optimal performance for data and process intensive transformations.

Environment: Informatica Power Center 8.5, Designer 8.5, Workflow Manager 8.5, Repository Manager 8.5, Workflow Monitor, Sybase, MS Sql Server, T-SQL, Dbartisan, Lotus Notes, Windows, Unix, Cygwin, Perl, Power Designer, XML, Visual Source Safe, .Net etc

Confidential, Hartford, CT

SENIOR CONSULTANT /TEAM LEAD

Responsibilities:

• Participating in concept through design/development/testing of the entire ETL Process.
• Involved in Designing of ODS, Star Schema and Staging area.
• Involved in developing a Standard/ Best Practices for ETL. Documented mappings,
• Process and Process Flow. Involved in designing a Process Control and Error Processing
• System, for Balancing and Auditing the transaction metrics and for Capturing Errors in complex ETL mappings/Workflow.
• Data Sources include Mainframe, Excel Spreadsheets, Flat Files and relational databases.
• Used Striva Detail (Power Connect) to Read and Write data from mainframes files and Cobol Sources. Did Incremental Updates, used constraint based loading etc.
• Developed Complex mappings for Claim and Premium Loading (Conversion and ongoing). Designed and developed complex Mapplets, shared by different Processes.
• Developed reusable shared transformations. Created sessions, Sequential and Parallel
• Running batches (tasks, worklets and workflows). Used dynamic look ups, Streams.
• Used session, mapping, workflow variables, Created partitions, databases indexes and fine tuned the mappings/sessions to improve the performance of the ETL process.
• Informatica Power Center Administration on Unix Platform.
• Installed and Configured the PMREP Server and PM Server on Unix Platform.
• Configured Power Connect (Striva Detail) and Integrated with Informatica Server.
• Did Administrative duties of Power Center on Development and QA environments.
• Used AUTOSys on Unix platform to Schedule the ETL Process, using PMCMD, wrote Unix Shell Scripts.
• Leading the Data Warehouse - Reporting initiatives.

Environment: Informatica PowerCenter 6.2, Designer 6.2, Workflow Manager 6.2, Workflow Monitor 6.2, Repository manager 6.2, PowerConnect ( Striva Detail ), Toad,Oracle 9i, Cobol, Unix, AutoSys, Web Focus

Confidential, Harrisburg, PA

DATA ARCHITECT/ Oracle DBA

Responsibilities:

• P articipate in the Analysis and Design of the Conceptual, Logical and Physical Star Schema.
• Designing the Staging/ODS Environment for the Warehouse using Oracle Replication to Minimize impact of ETL in Transactional System. Configuring the Windows 2000 Server for Database Creation. Capacity Planning and Designing Database Physical Architecture.
• Proactive management of database and file systems for growth of database.
• Designing, Creating and Configuring the Database. Designing and Creating the Oracle Management Server for Oracle Databases. Physical and Logical Backup / Recoveries of the Databases using Recovery Manager. Automating the Replication, ETL, Backup and ETL Process using OEM. Assist in Designing and developing Data Cubes and reports for Cognos Web based Reports. Administering and Tuning Web based application and Database for optimal performance. Performing DBA activities in Development, Testing, UAT and Production Databases. Installed/Configured the Informatica PowerCenter.
• Administering the Power Center Repository. Backup/Recovery of PM Server, Created and Migrated Repository and Folders for Development/Testing/Production Environment.
• Did Export / Import of Informatica Registry. Created Groups, Users and Set up the Security for the ETL Server.
• Created Database Connections. Performance Tuning the ETL Mapping using Database Indexes, Parallel Running of the Data Load etc.
• Applying Patches to Database, Migrating the Database, Installing the Software Upgrades.
• Monitoring the Data Loads and Data Cubes Creation, 24X7 Production on call Support.

Environment: Oracle9i, Enterprise Manager, SqlPlus, Oracle Management Server, Cognos Impromptu, Powerplay, Informatica Power Center 6, Designer 6, Repository Manager, workflow Manager, Workflow Monitor, Windows 2000, Veritas Backup Exec 8.60. Apache, Erwin, SAS

Confidential, St. Paul, Minnesota

Lead Data Architect / Data manager

Responsibilities:

• Perform Data Analysis and involve in designing Data Models for Different Reporting Applications and suggesting required changes in the OLTP, ODS and ETL environment.
• Involved in Researching and Re-Architecture the ETL environment and Coming up with a design for a Staging area to consolidate the Order and billing details at an Enterprise Level.
• Involved in Confirming the Scope of applications. Designing CRUD matrix. Gathering business and technical Meta Data Definitions. Keeping models aligned with multiple concurrent initiatives to ensure efforts are integrated with Corporate Data Strategy.
• Supporting the EDW developments on Subjects like Client, Account, Billing, Discounts, Order, Product, Pricing (Retail, Wholesale), Shipping, Catalog, Internet Session etc.
• Detailed GAP analysis on new reporting initiatives and existing Data Marts.
• Designing the Normalized as well as Star/Snow Flake Schema Models (Conceptual and Logical) for different projects. Modeling summary and aggregation tables for the WEB based reporting applications to improve the performance using Materialized Views.
• Modeling conforming dimensions for Client Definition (Client base include Banks, Credit Unions and other financial institutions). Identifying the Data Dependency.
• Analyzing the changes in Operational Data Store and evaluating its impact in the EDWH.
• Evaluating current business trends and studying its impact in the EDWH.
• Studying the Data Architecture for Aspect Call Center ECS Server and Data Mart products.
• Participating in the Enterprise Data Architectural Meetings (Business and Technical)

Environment: Oracle 8i, PL/SQL, Data Model Repository & Power Designer, Informatica Power Mart 5.0, Server Manager, Repository Manager, DB2, Business Objects, Web Intelligence Tools, Unix, Windows NT, SQLPLUS, Toad, Visio etc.

Confidential, Columbus, OH

TECH LEAD (DATA WAREHOUSING)

Responsibilities:

• Interact with users to understand, study and analyze the business problems.
• Modeling processes with Use Cases and Activity Diagrams. Created data flow and functional hierarchy diagrams.
• Map interfaces and extend the processes to customers
• Developed the system from scratch to production implementation.
• The design enables the users to drill from summary data to details.
• The system has an n-tier front-end architecture with Java and JSP User Interface and reports, report business logic in middle tier and Oracle 9i/8i database in back end using WebLogic Web server 5.1 and connection pooling.
• Designed Surrogate Key lookup tables to keep track of changing dimensions. Designed Data Staging Areas (Back Room) for the warehouse.
• Designed Summary tables and Materialized Views for Data Publishing. Did integrity and quality check of data in the Staging Areas.
• Standardized data elements, filled data gaps, extracted, cleansed, reconciled, transported, summarized and aggregated data from ODS, online and external systems and loaded into DW
• Planning a Testing strategy for DB using dump data based on requirements and functionality.
• Prepared Migration Strategy and test cases for UAT, based on design documentation, use cases, user acceptance test.
• Optimized long running complex Star queries using SQL Lab, Explain Plan, and Tkprof etc.Created Materialized Views, Tuned queries to run Parallel and to use query rewrite.
• Created bitmap and compound indexes, designed partitions.

Environment: Oracle 9i/8i, PL/SQL, Model Mart & ERWin 3.5.2, SQL Loader, SQL*Lab, Web Logic Web server 5.1, PVCS, InfoMaker, TOAD, Java, Servlets, JSP, HTML, HP UNIX, FTP, Sun/Solaris, XML, Perl, Shell Scripts, JDBC