SUMMARY:

• Core expertise in delivering large complex development and support projects providing highest quality analysis, design, development and support of business critical solutions.
• Proven track record in delivering sound systems solutions for business opportunities & users productivity. Worked closely with all stakeholders to ensure that IT is adequately supporting and being supported.
• Excellent communication, interpersonal skills and a team - worker with good customer interaction.
• Strong technical skills encompassing in-depth knowledge of key system development methodologies to streamline design, development and refinement of applications that reduce costs and improve productivity.
• 7+ Years of FRB Cash Analytics experience.
• Directed and hands-on involvement in all aspects of Data Strategy, Business Intelligence, Data Warehousing, Meta-data management, Enterprise data integration.

EXPERTISE:

Big Data Technologies: Hadoop 2.x Framework, PiG, HIVE (Big Data), Tableau, Pentaho, xoom data, scoop, flume, oozie, impala, HBase, Cassandra, Mongo DB, kafka, spark, CDH, HDH, Solr, HPE Volt, H2O

ETL/ Reporting Tools: Informatica Power Center 9.5.1/8.1/ 7.1/6.2/5.1/4.7 , Power Mart 7.1/6.2/5.1/4.7 , SQL* Loader, Ab Initio, Business Objects 4.1/XI R3, Oracle Data Integrator 10.1.3.5, Micro strategy 8.1/10.7, BI Dashboards, Lumira, Tableau and Cognos, SSIS, SSAS, Microsoft BI

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema, Snow-Flake Schema, FACT and Dimension Tables, Physical and Logical Data Modeling, ERWIN 4.2/3.5.2/3. x

Databases: Oracle 11g/10g/9i/8i/8.0/7.0,MS SQL Server 2016/2012/2008/2000 , DB2 8.0/7.0, Teradata, Netezza, HBase (Big Data)

Languages: C, C++, Visual Basic 6.0, PL/SQL, SQL, SQL*Plus, Transact SQL, HTML, DHTML, Unix Shell Scripting, PERL

Web Technologies: Java, JSP, ASP, XML, VBScript .Net Framework

Servers: IIS 6.0, Apache, Tomcat, Oracle 9i App Server, Web Sphere 7.x Application Server

Productivity: Office Suite 2007, FrontPage, Info Path, Outlook, Adobe Suite

Products: Oracle Retail, Epic, ICD9.0, JDA Manugistics

Platforms: Windows 2003 Server, UNIX, Red Hat Enterprise Linux, Sun Solaris 2.7/2.6,HP-UX 10.20/9.0, IBM AIX 4.3/4.2/5.1, MS-DOS 6.22, Win 98/95/3.x, Win NT 4.0

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Manager -DW/BI/BigData (Securities Accounting & Capital Markets)

Responsibilities:

• Manage DataMart and BI visualization projects within Capital Markets.
• Lead a team of 17 technical team members, including Developers, Data Modelers, Architects, Testers, etc.
• Big Data PoC use cases for Capital Markets.
• Direct all aspects of data strategy including enterprise data architecture, business intelligence, data warehousing, meta-data management enterprise data integration, DB modeling and DB design.
• Program planning and deliver critical business value, on-time, using Agile Methodology.
• Management and delivery of Information assets to the business stakeholders.
• Road map creation & creating release planning to achieve High Priority Objectives of the organization using Agile framework.
• Manage PM’s on EDW and BI projects.
• Management and hands on experience with Informatica, Hadoop, Oracle, SQL Server (SSIS), Teradata, Tableau, MicroStrategy and Business Objects.

Confidential

Sr. Data Warehouse Manager/ BigData//BI

Responsibilities:

• Managed Big Data/Data lake implementation at Confidential domain using Cloudera Frame work.
• Established and implemented policies, procedures, roles and responsibility and enforcing rules of engagement, decision rights.
• Program planning and delivered critical business value on-time using Agile Methodology.
• Management and delivery of Information assets to the business stakeholders.
• Road map creation & creating release planning to achieve High Priority Objectives of the organization using Agile frame work.
• Manage PM’s on EDW and BI projects.
• Led a team of 12 technical team members, including Developers, Data Modelers, Data Architects, etc.
• Management and hands on experience with Informatica, Hadoop, Teradata, Tableau, Cognos, Microsoft BI.

Confidential, San Francisco

Manager, Projects

Responsibilities:

• Architected & delivered critical business value, on-time, high quality business intelligence solutions.
• Multi-year program fully replaced previous ETL (SQL Server 2008) and business intelligence solution using SAP Business Objects, Dashboards & data marts.
• Project Planning and effort estimation. Working with Business stakeholders to establish and execute Analytical road map.
• Big Data PoC use cases for Cash application. Familiar with all Big Data tools including Map Reduce, PiG, HIVE and HBASE.
• Managed scope, end user expectations, and provided work estimates to manage a development team to support analysis.
• Participating and contributing in the development and review of the conceptual architecture and high level design of major projects and system enhancements across the full range of the Fed Cash Central IT portfolio, assuring conformance to IT standards and fulfillment of requirements
• Established and implemented policies, procedures, roles and responsibility and enforcing rules of engagement, decision rights.
• Management and delivery of Information assets to the business stakeholders.
• Participating in the development and maintenance of Fed Cash central application architecture and data architecture information, providing conceptual models, strategies, and long term technical directions.
• Led a team of 17 technical team members, including MS SSIS Developers, Architects, Data Modelers, BI Developers, etc.
• Directed all aspects of data strategy including enterprise data architecture, business intelligence, data warehousing, meta-data management enterprise data integration, DB modeling and DB design.
• Management and hands on experience with SSIS, SSAS, SQL Server 2008/2012, Informatica, Hadoop, Oracle, Tableau, Business Objects.

Confidential, Richmond, VA

Sr. Architect Data Warehouse & BI- Merchandizing Systems Transformation

Responsibilities:

• Development Project Manager for an Enterprise Data Warehouse (EDW).
• Responsible for day-to-day task and resource management.
• Communicated project accomplishments and issues on a regular basis via written and verbal means to Senior Management, including the project sponsors who were the CFO, the CIO.
• Directly managed a team of Seventeen, including Business Analysts, ETL developers and Data Architects.
• Responsible for the overall EDW Strategy and Architecture and leading the EDW Architect and designers.
• Individually developed the Project Plan and Budget, Project and Source Data Issues Communication Plans, Dashboard/Reporting Business Requirements Document and Corporate Data Conversion Guidelines
• Ensuring delivery of the project within the timelines and with high quality
• Oversee short-term and long-term system developments projects and strategy
• Hands on experience with SSIS, SSAS, SQL Server 2008/2012, Informatica, Oracle, Cognos, Business Objects.

Confidential, Silver Spring, MD & Pasadena, CA

Foundation Systems/Sr. Data Warehouse Project Manager

Responsibilities:

• Project Planning and effort estimation
• Ensuring delivery of the project within the timelines and with high quality
• Managed scope, end user expectations, and provided work estimates to manage a development team to support analysis.
• Directly managed a team of eleven, including Business Analysts, ETL developers and Data Architects.
• Lead application analysis and support efforts, includes instituting support processes and triaging Oracle application issues.
• Managed Vendor evaluation and Procurement of software products with Vendor Management Office.
• Established IT Development and Application Support processes and procedures to enhance the productive within IT for better customer care.
• Hands on experience with SSIS, SSAS, SQL Server 2000, Informatica, SSIS, Oracle.

Confidential

EMR Team Lead

Responsibilities:

• Electronic Medical Records(EMR) development
• Project Planning
• Requirement Analysis
• EMR Design and Development of ASP web pages
• Testing and Testing supporting during QA
• DBA Activities on development environment
• Testing and Testing supporting during QA
• Design Reviews
• Code Reviews

Confidential, Gaithersburg

Team Lead

Responsibilities:

• Project Planning
• Requirement Analysis
• Design and Development of ASP web pages
• Testing and Testing supporting during QA
• DBA Activities on development environment
• Design and Development of UI using Cool: Gen 4.1a
• Testing and Testing supporting during QA
• Design Reviews
• Code Reviews
• Code enhancements of batch programs using Pro *C++ (Using OCI features)