SUMMARY:

• Experienced in handling multiple engagements in various capacities as Data Warehouse architect, ETL Architect, Designer and Developer with a strong background in Design, Development, Implementation, Administration and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica PowerCenter 9.x/8.x, IDQ Informatica Data Quality .
• Extensive knowledge and expertise in Data Warehousing and Business Intelligence area. Proficient in Informatica Designer Components Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. Experience in Developing Mappings, Mapplets and Transformations like Router, Normalizer, Joiner, Update Strategy, etc. between Source and Target using Informatica PowerCenter Designer
• Strong Experience in SQL Server Integration Services SSIS , Data Transformation Services DTS and SQL Server Reporting Services SSRS .
• Played pivotal roles as an engineer and architect across domains
• Understanding of Big data technologies - Hadoop, MapR and Map/Reduce, Pig, Hive, NoSQL solutions like Hbase, Cassandra, MongoDB, CouchDB as well as MPP databases like Netezza
• Expertise in SQL databases Oracle/SQL Server/MySQL , Analytics platforms e.g. Pentaho, BO or similar and OLAP technologies
• Understanding system architectures to plan for future data integration strategies for SAAS cloud implementations
• Identifying business' implementation/go-live pain-points risks that would help narrow down the potential vendor from the market
• Proven ability to lead a team of engineers, passion for technology and willingness to learn
• Key decision maker in the requirements gathering for both the initial phase and future possibilities of a Data-integration/Data Discovery tool
• Provided an RFP/Project Plan for the stake-holders with clear technical requirements for phase 1
• Evaluating Proof of Concepts, Talend vs Birst vs Mulesoft against other key players from Gartner's magic quadrant report
• Domain knowledge of Time Attendance, Securities industry and Portfolio Management practices including portfolio analysis, reporting, financial modeling risk analysis
• Experienced in Relational Databases RDBMS , Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying. Implemented Ralph Kimball methodology in designing DWH and Enterprise DWH systems. Used extensively Erwin Microsoft Visio for data modeling tools. Designing, implementing and testing of various ORACLE ERP applications using Case Tools like Erwin, Designer 2000, UML Oracle CASE
• Efficient with Conceptual and physical data flow diagrams, Enterprise Data Warehouse Design, Operational Data store Design, Data mart Design and entity relationship diagrams using ErWin and making extensive use of UML and Design Patterns to keep up to date with all technical developments in the field. Organized existing data models, data flows and data dictionaries into a MetaData Repository. Created physical models of all databases.
• Ability to work at multiple levels of metadata management project, including defining the metadata management architecture, managing the metadata project, mentoring metadata developers. Implement metadata standards for the developers to ensure completeness and accuracy
• Attended workshop to gain experience with open-source technologies, exposure to big data processing using NoSQL techniques like Cassandra, Hadoop, and Hive. Currently, exploring clustering and sharding features of Mongo DB.

• Knowledge and/or hands-on experience with metadata management tools such as IBM's MetaStage, Informatica's SuperGlue, CA Advantage Repositories, ASG Rochade, Adaptive, MetaMatrix or DAG MetaCenter
• Familiarity with administration of custom complex JAVA applications in Tomcat/J2EE environment.
• Proven track record of client facing roles within both government and commercial arenas. Always excelled in customer facing roles and demonstrated strong client empathy. Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support. Have solid background on data analysis and up-to-date database technologies especially on Oracle expertise on components that implement reusable transformation and ETL extract, transform and load strategies across different technologies, Business Intelligence
• Efficient in trouble shooting, performance tuning, and optimization of ETL and reporting analysis.
• Developed and tuned data-migration to migrate user data to production database scripts that decreased run time from days to minutes.
• Provided top-notch DBA services and able to switch between capacities effortlessly: production support and development support. For development support, performed numerous DBA tasks including a complex mission-critical data and schema migration across numerous tables for development support provided clear and concise technical information that enabled DEV/PERF/QA/Analysis team to design test cases and scenarios that exercised the application effectively
• Employment Status : Green card

EXPERIENCE:

Confidential

Project Manager-Technical/Lead Data Architect

Achievements and Responsibilities:

• POC for Emergency/High-visibility production issues that need immediate resolution integral member of the Emergency JCCB team
• Created LDMs logical data model PDMS physical data models of Agency and Reporting databases. Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.
• In addition to transactional OLTP system, created Data Structures for Corporate Data Warehousing for Decision Support Systems DSS-CARS . Analyzed, designed and created the Data Warehouse model which includes, data structures, Meta Data, and design to transform and load data into warehouse. Also looked into aspects of Multidimensional Databases verses the Relational/OLAP. Worked on data warehousing component from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management and executives, business sponsors and IT department
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager. Designed Informatica mappings by translating the business requirements. Developed mappings for Sales, Orders and Orders Received metrics. Studied Session Log files to correct errors in mappings and sessions. Wrote pre session and post session scripts in mappings. Performed data manipulation using basic functions and Informatica Transformation. Performed unit testing for the mappings using SQL scripts. Wrote SQL overrides in source Qualifier according to business requirements. Developed PL/SQL Functions, procedures as per requirement and called them in transformations. Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Designed and created data model for Data Warehouse needs. Developed processes to extract, transform and integrate ETL operational data into data warehouse.
• Designed and developed SSAS OLAP Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, dashboards or scorecards based on business requirements.
• Created SSIS Packages to import and export data from Excel, XML and Text files.
• Facilitated JAD sessions to gather the data warehouse requirements from the users. Designed a three tier based Data Warehouse architecture. Worked with business users to define and analyze problems, create logical data model, implement physical data model, and considers the implications of business solutions to the current and future environment.
• Lead architect for the Data-Analyzer report which identified anomalies in data-contracts across all the application domains and produced a daily/weekly report for the Central Agency Admins to fix via environment data-fixes.
• Designed, developed and supported the Configuration Analyzer report which produced a list of config-data deltas to the application architect for analysis/review and finally fixing them. The RCA Root Cause Analysis document not only highlighted the cause of the problem but included the short-term and long-term fixes that could be implemented by the project stake-holders after consultation with the DEV teams.
• Designed, developed and successfully implemented in-house PL/SQL coded ETL Extraction, Transformation Loading process for the highly complex reporting system. Also implemented Real-time ETL processing using Oracle Streams and Advanced Queues for data replication , the BI tool being Cognos. Denormalised the data on the reporting database for optimal speed and accurate data retrieval.
• Involved in the Oracle 11gR2 migration process, exploring the new features and testing.
• Cutover data-migration lead DBA/analyst responsible for getting government agencies on-board City time . Developed a home-grown PL/SQL data-migration suite that loaded data from a PRAT Production Readiness acceptance system to a live PROD system. This was key to getting government agencies to use the Citytime system for time and attendance and eventually getting paid on time. Designed, developed and implemented pre-ingestion and post-ingestion processes to ensure smooth data-migration inclusive of validation checks.
• Performed a System study of IBM InfoSphere DataStage that is used to integrate data across multiple systems using a high performance parallel framework, via extended metadata management and enterprise connectivity. The scalable platform provides more flexible integration of all types of data, including big data at rest Hadoop-based or in motion stream-based , on distributed and mainframe platforms.
• Test-data chief architect in liaison with System Test/User Approval test/Performance Test teams. DB lead for designing and developing Selenium cactus testing, which were automated testing for the DEV team.
• Created and maintained schema objects such as tables, views, clustered indexes, procedures, triggers.
• Used Triggers to implement business logic and for auditing changes to critical tables in the database.
• Wrote stored procedure and user defined functions to reduce network traffic and latency also to boost application performance.
• Participated in business requirements gatherings prepared technical design specifications
• Employed Indexing Strategies and optimizing them, using SQL Profiler
• Partitioned lot of tables, which have frequent inserts, deletes and updates to reduce the contention and to improve the performance.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Wrote UNIX Shell Scripts to schedule these activities.
• Performed database/SQL tuning to improve the application performance. Used EM to identify high-resource consuming SQL and Performed SQL Tuning by running Explain Plans, gathering statistics, and rewriting the queries by using Hints.
• Used AWR reports for understanding and troubleshooting the performance problems in several databases. Performed several levels of tracing, including session level, database level by using SQL TRACE, DBMS SUPPORT, DBMS SYSTEM and other methods to identify and troubleshoot performance issues. Performed SQL tuning to improve the performance of the reports.

• Reviewed work items produced recommendation documents at various stages of the project
• Developed and Maintained the Central Deployment Services website that used a combination of XL-VBA code to automate data delivery that was used by the business, analysis and testing teams on a daily basis for build development, promotion, training and testing.
• Perform effort estimation/LOE and assist Configuration Management teams for build promotion/problem resolution
• Meet project deliverables as per requirements, on time within budgets

• Data-Architect/DBA role along-with hub-center liaison between Development/Agency Administrators/Analysts/Requirement/Training teams liaised with various agency business development teams to prioritize and implement business requirements interacted with Team Leads and senior management to finalize data model related architectural decision
• Managed database activities during the entire development life cycle of the Citytime project. Main responsibilities included specifying the database architecture, designing the physical and logical database, optimizing the database, setting up DBA procedures and assisting in tool selection. Created Indexes for faster performance and Views for controlling user access to data
• Led various strategic efforts including a conceptual data model for all of R D and a master data management plan
• Used exchange partitions to sync up data across databases when they went out of sync due to an oracle streams-bug
• Supported multiple databases in a production environment.
• Application support via development DBA tasks like IR Incident Report creation, resolution deployment
• Design, develop implement the Reconciliation process across databases for data-validation and integrity. This was done at 2 levels the first level was against 2 Oracle databases while another level was between Oracle and Synopsys.
• Design different kind of Data Models and DFD's Data Flow Diagrams for different kind of databases by using ERWIN and Visio 5.0.
• PL/SQL scripting, Performance Tuning and Monitoring Unix shell scripting

Environment: ETL Informatica PowerCenter 9.x/8.x Hotfix 12, PowerConnect, Data Explorer 8.6, Data Quality 9.x Informatica Power Center 9.x/8.x - Designer, Repository Manager, Workflow Manager , Autosys, Oracle 11g/10g, SQL server 2012/2008/2005, SSIS, SSRS, Cognos 8.0, Sun Solaris, RMAN, PL/SQL, ERWIN and Visio 5.0,Veritas HA, Netbackup, LDAP, Rational Clear Case, Clear Quest. PVCS Tracker, Visual Source Safe, Sunopsis software, WebSphere, Kintana.

Confidential

Data Integration - Lead Architect

• Created logical and physical database designs using ERwin.
• Involved in designing enterprise level Single Sign On database.
• Designed and developed Extracting and Transforming data strategies using DTS, SSIS, SQL Server Import Export, Bulk Insert and BCP.
• Created drill down, drill through, sub and linked reports using MS SSRS as well as managed the subscription of the reports.
• Migrated all DTS packages to SQL Server Integration Services SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Played a major role in production support of SSAS cube and SSIS jobs
• Experience in creating drill down, drill through and linked reports using SSRS SQL Server Reporting Services and Crystal Reports with multi-valued parameters and LOV's
• Analyzed, developed, designed and implemented Oracle database/data warehouse solutions.
• Designed and developed an object-oriented database environment based on a relational database kernel. Main responsibilities included design and development of a DDL compiler and its interface with the database kernel as well as optimization of the entire environment.
• Architected and implemented change data capture and slowly changing dimension design. Performed dimensional and 3NF modeling according to enterprise standards using ErWin, UML
• Developed custom PL/SQL Procedures as a part of Data Warehouse ETL to load data from flat files to Data warehouse on a weekly or monthly basis.
• Capacity planning, Performance Tuning of production Oracle databases
• Detect, Diagnose and Resolve database Performance Problems
• Implemented efficient backup and recovery procedures using best practices.
• Wrote complex stored procedures, functions, Packages and Database triggers for various financial business applications.
• Wrote application-supporting packages using Oracle XDK and Oracle XML Parser.
• Development of shell scripts to operate various processes on UNIX environment
• Oracle 9.2.0.x installations, SQL Server installations and tuning database queries using Explain Plan, TKPROF and Oracle trace utilities.
• Used Export/Import and SQL Loader tools for data transfer and migration.
• Migrated 200GB financial database from Oracle 8.1.7 to Oracle 9.2.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Presented a case study on Oracle 10g New Features to senior management

Environment: Oracle 8.1.7/9.2, SQL Server 7.0, Tidal Batch scheduling, PLSQL, ERwin, Oracle Enterprise Manager OEM , Data Guard, TOAD, Windows NT, SQL Server and IBM AIX, RAC, RMAN, UML, Oracle CASE.

Confidential

Data Integration - Lead

Web enabling their existing environment. Created a homogeneous database system to store and retrieve large documents stored in the form of XML. Business objects resided in the Oracle/SQL server database and JSP front end uses Oracle objects to retrieve and present data on web browsers.

• Involved in Design, analysis and development.
• Created Logical and physical designs of databases using Erwin and assisted in the development and delivery of Analysis and Design documents using UML.
• Involved in Database Reverse engineering of three legacy databases.
• Developed SSRS reports, SSAS OLAP cubes, dashboards or scorecards
• Wrote automation scripts to migrate data from old schemas using PL/SQL.
• Database support for Performance tuning, backup planning and implementation, installation and configuration of new systems
• Performed Oracle database development using PL/SQL and Shell Scripts.
• Technical support for developers in design, tuning, build enhancements and problem resolution for test, development, production and reporting databases
• Wrote java-stored procedures using XML API's.
• Backup and Recovery, both manually and using RMAN. Capacity Planning and performance tuning, code tuning using explain plan and hints
• Import/Export utility was used to do import Export of the old schemas.
• Designed the Disaster Recovery Plan to set remote DR site
• Used SQL loader to load data into the new database.
• Developed shell scripts to automate tasks and increase productivity.
• Wrote stored procedures functions, Database triggers.
• Made extensive use of new Oracle8i packages to port large objects from old schema.
• Designed access security for database objects and system level security for managing privileges.

Environment: Oracle 8.1.7, SQL Server 7.0, Tidal Batch scheduling, Oracle Forms/Reports, PL/SQL, RMAN, ERwin, UML, Oracle Forms/Reports, XML, Oracle Enterprise Manager OEM , Designer 2000, TOAD and Solaris, SQL Server, Biztalk Server

Confidential

BP / OM Customer care Integration

• Oracle 8i installations.
• Designed and Data modeling new business requirements.
• Performance tuning of the existing PL/SQL and SQL scripts.
• Analyzed Legacy data in various Access and RDB database.
• DBload from same legacy systems to the Oracle 8i environment.
• Provided technical consultation to improve the performance of Oracle 8i DB.
• Provided technical consultation to troubleshoot and Performance improvement of SQL query of data replication environment.
• Conducted IPA Integration Point Analysis sessions to iron-out the doubts/ reservations between the development and user teams

Environment: Oracle 8i, Korn shell scripting, HP UX server in a clustering environment, SQL Server, PL/SQL Developer, Oracle Forms/Reports, Crystal Reports, Designer 2000, Factory Works Manufacturing application.