OBJECTIVE:

I am looking for a managerial or senior level technical position in Data Analysis or Data Architecting or Data Migration or Data Warehousing or Transactional Systems related information technology field.

SUMMARY:

• I have worked in diverse IT environments and have hands on experience/knowledge on a wide range of IT products. I also have good European Market exposure as I have led some development effort in Europe. I have successfully led many projects in my career. I think outside the box and have extensive knowledge and hands on experience with Systems Analysis, Design, Implementation, and Testing/Support and problem - solving skills in Business Intelligence, Data Architecting, Data Warehousing, Big Data and Transactional Systems related projects. I am a master in data architecting, modeling, development, integration, and migrations. Overall, I have over 15 years of hands on experience in Information Technology industry.
• I have solid 10 years of extensive experience in architecting, developing and building customized Relational Databases, Data Warehouses, ETL, Business Intelligence, and On-Line Analytical Processing ( Confidential ) applications for enterprise level systems.
• I have extensive experience in business requirements gathering and creating technical requirements and system requirements. Took part as well as led JAD sessions. Did detailed GAP Analysis, Impact Analysis, Data Mapping Analysis, and Integration Analysis. Also Documented, Designed and Developed, Application workflows, Process workflows, Data flow diagrams, and designed Conceptual models, Entity Relationship Diagrams ( Confidential ), and Logical and physical models. Also documented, developed, and maintained Data Sanity checks, Data validations and Data Dictionaries.
• Coordinated, facilitated, and took part in stake holder meetings, daily client meetings, understanding requirements, mentoring team mates, weekly status meetings\reports, and proposing and implementing latest BI, Data warehousing, and ETL solutions.
• Experience in end-to-end Microsoft SQL Server 2000 & 2005 & & 2008 & 2012 and Oracle 10g & 11g relational databases and Data warehousing Frameworks including Microsoft’s Analysis Services, Reporting Services, TSQL, DTS, SSIS, and other Reporting and ETL Tools including MicroStrategy, Cognos, INFORMATICA, Oracle Data Integrator, DATASTAGE, and Teradata utilities (Tpump, FastLoad, MultiLoad, FastExport). Have recent training experience in Hadoop.
• I have designed and developed Transactional Systems (3NF models) as well as STAR & Snowflake Schema logical, dimensional, and physical models for the Analytical layer.
• Created Dimensions, Lookups, Facts, Aggregates, and Confidential cubes with Drill through functionality. Also designed, developed, and maintained staging and target databases. Wrote custom\complex Procedures, functions, triggers, and designed & developed custom\complex packages. Wrote Customized Error Processing and Error Handling UDF’s (User Defined Functions) to resolve data issues (message queue’s and data feeds). Implemented SCD (slowly changing dimensions) techniques (types 1, 2, 3 and hybrid) for different Hierarchy dimensions for history tracking, data validation and integrity issues.

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect / Migration Specialist

Responsibilities:

• They wanted someone to analyze their current systems and manual processes and provide direction (solution) to a centralized Business Intelligence solution.
• My duties involved understanding their current business and technological needs, interviewing different business and R&D process stake holders, creating application workflows, creating process workflows, gathering data requirements, architecting end to end BI solution, and preparing Confidential road map.
• Also designed, developed, and presented BI proof of concept, and last but not least took part in vendor selection process.
• Other duties included understanding various R&D sub systems, documentation, daily meetings with scientists, and presentations.

Confidential

Senior Data Architect, Dallas, TX

Responsibilities:

• I was duly appointed to migrate and revamp all their Data Systems.
• My duties included meeting with business SME’s and technical team to gather business and technical requirements. Perform Post and Pre GAP Analysis.
• Presented Confidential ’s and attended daily\weekly client meetings.
• Based on the requirements, created Conceptual Model, and then upon approval created Logical Model and later converted it into a Physical Model.
• Followed all modeling methodologies\techniques and created a Data Model as close as possible to a proper 3nf model. Designed and Developed ETL solutions to migrate Data from multiple source systems into the newly developed Data Model - used inbuilt as well as custom transformation techniques.
• Built tons of SP’s, Triggers, Functions, Roles, Views to support upstream and downstream data requirements.

Confidential

Senior Data Architect, New Orleans, LA

Responsibilities:

• I was responsible to analyze their existing 25 year old main frame system and architect a client server n-Tier Data Model to support their day to day needs.
• My core responsibilities included: Requirements Gathering, GAP Analysis, Confidential, Logical/Physical Data Model, Data Migration Roadmap, JAD sessions, Confidential, Weekly Client meetings/demo’s.
• We successfully architected the relational database and migrated 25 years’ worth of research data from main frame system to the new Relational Transactional Research System.
• We analyzed and corrected all data integration and migration issues.
• Success was blooming when we pulled the plug from main frame system and pointed all the connections to new Transactional Research System.
• During the above described process, all System Testing, UAT testing, Staging, and all other protocols were followed before productionalizing the system.

Confidential

Data Migration Specialist / Senior Data Architect

Responsibilities:

• My duties included understanding current MDM data model and all the other source systems that would feed the new golden source.
• Created Data Mappings, performed GAP Analysis, created ETL packages, created daily\weekly\monthly data load jobs, wrote custom stored procedures\functions\triggers to support the overall migration.

Confidential

Senior Data Architect

Responsibilities:

• My responsibilities included understanding and analyzing the existing HR, Finance, Products, Services, Accounting, Ordering, Billing models and business requirements, defining technical requirements, defining Confidential, designing Logical and Physical Master Data Model, and data mappings to support different business needs. End product was one Repository that all business units/applications pointed to.
• All work was performed on MS SQL Server 2008, Oracle 10G, ERWIN 7.3.
• MS SSIS technology was used to perform ETL tasks and SSRS for reporting purposes.
• Also built Confidential subject areas in PIVOT and reporting format in MS Excel to present to the business for approval before further development.

Confidential

Senior Data Architect

Responsibilities:

• Part of my responsibilities included Project Management, Team coordination, and Project Facilitation.
• Other core responsibilities included designing Campaign Management System, creating and updating Marketing Engines for clients, gathering marketing data from clients, developing in house Data warehouse system to analyze the marketing trends, producing executive reports and more…
• Daily tasks include meetings with stake holders, transactional Data owners, and SME’s to facilitate requirements session.
• I have developed the campaign/promotions logical data model.
• I am currently in the process of creating Physical Data model.
• Once the Physical Dimension model is created, I will design and develop the ETL process to extract data from different marketing databases including dumps received on daily and weekly basis from different client’s transactional systems.
• All work will be performed on MS SQL Server 2005 but other platforms where the data will be extracted from includes Oracle, DB2, Flat files, Confidential ’s.
• Once the Data is warehoused, I will analyze the data to confirm it’s sanity to business/technical requirements;
• I will develop Confidential cubes and produce Adhoc and Canned Reports based on the business/technical requirements…
• Will definitely have to write SQL procedures, queries, ETL routines, functions, messaging/sanitizing routines, and roll back mechanism for data population (ETL). Will also be responsible for documentation, status updates, flow charts, team and client presentations, and more…

Confidential

Tech Manager, Irving, TX

Responsibilities:

• Successfully lead project teams. Responsible for team management, project plan, scope, and budgeting for the project. Played different roles on different projects.
• Apart from management, I was also involved in development efforts.
• As an Oracle9i\10G and SQL SERVER 2005 Transactional Systems Lead Data Architect/Developer was responsible for data Modeling, Analysis, Extraction, Transformation, Loading, and Development of highly transactional and reporting databases.
• Created and maintained both Dimension as well as functional ER model for the transactional system.
• I was also responsible for the solution architect role.
• Led data preparation, data analysis, and data gathering sessions\efforts and proposed solutions based on the respective gaps. Designed, directed, and helped teams to created custom stored procedures, tables, indexes, triggers, and functions to support the over all project. Also performed extensive work with PLSQL and TSQL.
• Created complex stored procedures and functions to accommodate the front end procedure calls.
• All work was performed on HR and Finance related data.
• Task was to first create a data extraction engine in Oracle to stage data in PeopleSoft and then extract, transform, massage, and load the PeopleSoft’s staged data into SQL Server 2005. Was also responsible to Extract, Transform, and Load XML data from flat files into SQL tables.
• All worked was performed on MS SQL Server 2005, Oracle 9i\10g, and MS Excel 2003. Developed and maintained very complex SSIS packages, created jobs, execution plan, and DB maintenance plans.
• Developed very complex tasks to accommodate complex backend system logic in SSIS.
• SSIS packages were fully automated.
• Also took part in Merge Replication process, bug triages and tuning the DB and stored procedures.
• Lots of hands on experience with Oracle9i\10g and SQL Server 2005 and its SSIS ETL tool. Also documented end to end backend process.

Confidential

Tech Manager, St. Louis, MO

Responsibilities:

• As a Database tech Manager was responsible for validating, developing, and testing the marketing reports.
• Took part in developing Confidential cubes and producing Adhoc and Canned Reports.
• Also tuned SQL procedures and queries for data population (ETL).
• Performed both system testing, and functional testing on the Marketing Portal.
• Wrote test cases, logged bugs, and took part in bug triage meetings. based on the installation steps provided, also performed application installation testing on UNIX platform.

Confidential

Tech Lead, San Jose, CA

Responsibilities:

• Team management, analyzing and gathering of warehouse data, and developing and validating marketing reports for the client.
• Took part in developing Confidential cubes and producing Adhoc and Canned Reports.
• Also tuned SQL procedures and queries for data population (ETL).
• Was also responsible for documentation, status updates, flow charts, team and client presentations, and…

Confidential

Technical Manager, Reston, VA

Responsibilities:

• As a Technical Manager was responsible for team management, budgeting, project plan, and scoping.
• Also directed teams as well as took part in Creating, Analyzing, Designing, and Implementing a fully functional ER modeling and Dimension Modeling for VOIP System for Registration and Marketing Departments.
• All work was performed on core Oracle 10g, Toad 8.0, Erwin, Microsoft Access 2000, and Microsoft Excel 2000 - all deployment was done on Linux clustered environment.
• Developed Packages, Procedures, Triggers, Jobs, and other business objects based on the business requirements provided.
• Oracle Data Integrator was used for ETL/ELT processes.
• Also led and managed the effort of analyzing, designing, and implementing a mini data warehouse to host warehousing data for VOIP.
• Lot of ETL work was performed to extract the data from flat files, Confidential ’s, tables and transform and load them into the staging tables.
• After successfully loading the data, some massaging of the data was also performed to bring data into usable form. Using this warehouse designed and coded daily, bi-monthly, and monthly Marketing and Finance reports for the client. These reports were spit out onto the finance servers in the form of Confidential ’s.
• Was also responsible for daily interaction with third party companies supporting the VOIP project.
• Other duties included daily interaction with the international teams, day-to-day conference/hurdle calls, and managing part of team in Europe.
• Have good exposure to the European markets, as part of engagement was to go to Europe and manage the DB team there.
• Version Controlling was very strictly taken care of throughout the project using WinCvs.

Confidential

Development Lead, Atlanta, GA

Responsibilities:

• As a Project and Technical Lead was responsible for Gathering, Analyzing, Designing, and Implementing a fully functional ER modeling and Dimension Modeling for Retail Management System for financial departments.
• All development was performed with core SQL Server2000, Microsoft Access 2000, and Microsoft Excel 2000. Also Designed, Created, and Implemented PivotTables Reports.
• These reports are refreshed every Microsoft based fiscal period with all data headers changing/refreshing dynamically. Also created/wrote Technical documentation and System Requirements documentation based on the Business Rules and the actual physical system.
• Designed and implemented DTS packages to stage data in the data warehouse.
• Some data massaging and cleansing was also part of the project.
• Data was extracted from different Legacy systems using DTS and was uploaded into custom tables using stored procedures/triggers/views.
• Also organized daily and weekly internal and client meetings to discuss the status, open issues, and concerns to the project.

Confidential

Project Manager, Irving, TX

Responsibilities:

• As a Project Manager at Confidential was responsible to prepare working Project Plan to successfully deliver Confidential eCommerce Website.
• Used MS Project 2000 to design and create the project plan.
• Daily duties included team management, time management, internal and client team meetings, status updates, and budget management.
• From time to time delivered Power Point Presentations and reports to the executives.

Confidential

Senior Consultant, Irving, TX

Responsibilities:

• As a Project Tech Lead was responsible for design, development, porting and debugging of Confidential .
• All development was performed with core SQL Server2000, Teradata, Oracle, and mainframe legacy systems in developing, designing, and implementing a fully functional ER modeling and Dimension Modeling for OLTP and Confidential systems to support Confidential .
• Developed/wrote hundreds of stored procedures, triggers, and functions to support the front-end data needs.
• Day to day tasks also involved tuning indexes, tuning SP’s, leveraging horizontal and vertical partitioning...
• ETL tools were used to Extract, Transform, and Load the Data from different Legacy Systems.
• Custom Parsers and error handling components were developed using C/C++ and Perl and were integrated with ETL utilities.
• Different ETL utilities (BTEQ, CLI, BulkLoad, FastLoad, MultiLoad, FastExport, Tpump, and OLELoad) were used and custom scripts were written to Extract, Transform, and Populate the data .in Teradata Warehouse. Used Perl and C/C++ to parse, clean and Filter the Data Files.
• Also used C/C++ to develop custom AXMOD functions for custom transformations. Jobs were created and scheduled using Windows Scheduler to execute custom written Batch files which in turn started the ETL jobs.
• Also developed/wrote Stored Procedures, Functions, Triggers, Sequences, Indexes and Fact Tables throughout the development process.
• Also administered in space distribution, performance tuning and security of Teradata Datawarehouse.
• Also used Run Time Support (RTS) module for stored procedure executions.
• For development of stored procedures, functions, and triggers - QueryMan was extensively used and ETL was used to populate the Data into the Teradata Datawarehouse. All work was performed on Windows 2000 platform.

Confidential

Tech Lead, Dallas, TX

Responsibilities:

• As a Project Tech Lead was responsible for Gathering, Analyzing, Designing, and Implementing a fully functional ER modeling and Dimension Modeling for ATS systems.
• All development was performed with core SQL Server2000, Teradata, Oracle, and mainframe legacy systems in developing ATS system.
• Designed and Implemented DTS (Data Transformation Services) tools to Extract, Transform, and Load the Data from Multiple Legacy Systems.
• Developed/wrote hundreds of stored procedures, triggers, and functions to support the front-end data needs.
• Day to day tasks also involved tuning indexes, tuning SP’s, leveraging horizontal and vertical partitioning...
• Custom ActiveX Parsers and error-handling components were developed using C/C++ and Perl and were integrated with DTS/ETL utilities.
• Different DTS tasks and custom scripts were written and used to Extract, Transform, and Populate the data.
• All the Front End Development was done in Dot Net.
• Developed complex stored procedures and triggers to properly integrate according to the Front End needs.
• Wrote Multiple DTS packages and scheduled jobs to support the easy transformation and flow of data.
• Multiple Batch files were also written to handle windows based tasks to Create, Edit, Delete, and Update Directories and FTP daily incoming Flat Files.
• Wrote Custom Parsers to parse daily incoming files.
• Handled all tasks from Modeling to custom and complex queries to data integration with Front end.
• All work was performed on Windows 2000 platform.

Confidential

Development Lead, Richardson, TX

Responsibilities:

• As a Project Tech Lead designed a fully functional ER modeling and Dimension modeling to support Verizon.com corporate Order Entry/Customer application database (OLTP) and Decision support system.
• All development was performed on core SQL Server2000.
• Data warehousing techniques were extensively implemented in Extraction, Transformation and Loading of data from multiple databases into our corporate Order processing system.
• Developed/wrote hundreds of stored procedures, triggers, and functions to support the front-end data needs.
• Day to day tasks also involved tuning indexes, tuning SP’s, leveraging horizontal and vertical partitioning...SQL utility, DTS - Data Transformation Services, was used to create custom Packages to extract, transform, and load the data from different legacy systems. Involved in Data mapping between multiple data transaction and Legacy systems.
• Database triggers, Sequences, Indexes and fact tables were widely used in providing data integration and security. Successfully built SQL and PL/SQL scripts to maintain Order and Product information consistently in multiple systems with great accuracy.
• Packages, Procedures, and Functions were extensively used to improve the functionality of the program.
• Generated complex reports involving SQL Tuning and Data scrubbing using oracle-defined functions as per the business requirement. Worked on PowerMart, Repository Manager, Designer (Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer) and Server Manager.
• Source Analyzer tool was used to analyze various sources from relational database, flat files and to create new source definitions into the Repository.
• Warehouse Designer was used to create target table definitions by various methods.
• Mapping designer was used to connect source and target tables through combination of different transformation objects e.g. Source Qualifier, Expression, Filter, Aggregator, Update Strategy, Lookup, Joiner, and Sequence Generator. Various sessions were then created and executed using Server Manager.
• Involved in design and documentation of mappings and sessions to build and run them in scheduler and monitor for the successful loading of data into Data Mart.
• All work was performed on Windows 2000 platform.

Confidential

Developer, San Francisco, CA

Responsibilities:

• As a core team member was responsible for analyzing, designing, developing, administering, and maintaining a Real Time Video Server in Oracle database.
• Duties also included Configuration of other Oracle 8i servers.
• Also worked on Client/Server tools like Oracle 8i Server Enterprise Manager and SQL* Net to administer Oracle Clients, and used Oracle 8i System Tables to retrieve metadata.
• Used the Developer 2000 forms and modules to create the front-end GUI clients.
• Also created the Reporting system through the Oracle Reporting Tool present in the Developer 2000.
• Upon deployment, Oracle 8i was handling data over 54 GB and to increase performance and efficiency tuned the database using the options to grow or shrink database files and to monitor the size of the transaction log. Java - JSP (Java Server Pages), Servlet, EJB (Enterprise Java Bean) were used for front-end and Oracle 8i for the back end to store Real Time Video Clips.