PROFESSIONAL SUMMARY:

• Highly motivated and results - driven Leader with 28+ years of experience in Strategic Planning, operations, system development, architecture, process improvements, consulting, and vendor management.
• Over 13 + years of experience in Managing/Leading a Team of 25 members. Experienced with leading the team of Architects, Technical Leads, Developers, and Business Analysts.
• Experienced with the delivery of Enterprise/Solution Architecture for the Enterprise Data Warehouse (EDW) and Infrastructure Projects. Experienced with demonstrating the architecture solutions to the Enterprise IT Council, Architectural Governance committee, and Enterprise Architects (EA’s) etc.
• Experienced with Analysis, design, development and implementation of various ETL / OLAP / Reporting applications using SSIS, SSAS, SSRS, Cognos and Business Objects, SSIS, Informatica and Data Stage.
• Experienced with Big Data/Hadoop technologies (HIVE, MapR, PIG, HBase).
• Experienced with Database Administration, Database Migration, Capacity planning, Design, Development & Support with SQL, DB2, ORACLE and SYABASE .
• Experienced with Big Data, Hadoop (MapReduce, Hive, HBase etc.)
• Experienced with Data Management, Data Governance, Data Quality, Data security, Data Audit, Data Masking, Data Modeling and Data archival process.
• Experienced with Developing Portal and Web Applications using Share Point, JAVA, Oracle, SQL, .NET, VB, ASP, and J2EE .
• Experienced with the Meta Data Management (MDM) using the SQL Server MDS and integrated with Share Point and EDW. Experienced with Informatica MDM/SAP MDM/IBM MDM.
• Experienced with implementing the best Practices for the EDW, Business Intelligence, Share Point Portal, TFS, ETL / Reporting.
• Responsible for setting up the Security Architecture using ECG (Electronic Customer Gateway) and DRG (Data Release Governance) to send/receive the Files/Reports with PHI/PII Data.
• Experienced with preparing the new proposals (RFP) for ETL/Reporting projects.
• Experienced with various business/technical units in integrating various interfaces to build the EDW/Portals/Applications etc.
• Experienced with Project Management, Agile Methodology, ITSM (ITIL) Management, Quality Assurance, QA/Testing methodologies, Disaster Recovery solutions (Rapid/Hot), SOX and IT Audit.
• Experienced with Strong Business process, process flows. Experienced with Managing / Working with On-site/Off-site staff.
• Experienced with setting up Operational Goals and Project Priorities.
• Experienced with Benchmark Analysis, Stability of the Environment, Process Improvement, and Staff Management etc.

TECHNICAL SKILLS:

OS: Windows Server 2008/2003/2000/ NT, Windows 7 / XP, HP UNIX, Solaris.

Databases: Oracle, SQL Server, MS Access, DB2, TeraData, PDW, Pervasive, Sybase and MySQL.

ETL/BI: SSIS, SSRS, Informatica, DataStage, Cognos, Business Objects, SSASCrystal Reports, SAP BOBJ.

MDM: SQL Server Master Data Services (MDS).

Languages: C, C++, Java, VB, ASP, VB.NET, ASP.NET, C#, ADO.NET, VB.NET, ASP.NET

Software s: Power Designer, Erwin, Visio, Apachi, IIS, MS FrontPage, MS Office, MS Project, Shavlik, HPSM, HP Open view, ITG, Optim, Share Point 2013/2010 .

QA/Testing: Test Director, HP Quality center, QTP, Load Runner, Win runner, Selenium.

Misc. Tools: Red Gate, Idera SQL Diagnostic Manager, SQL Safe, OOAD, UML, Web Services, SOAP, SCOM, TFS.

Backup Tools: TSM, TWS, VERITAS, LITE SPEED, SQL Safe.

Hardware: IBM, Compaq, DL 380, DL 585 Servers, DELL Blade Servers, HP, Hitachi Servers, VMware

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise Architect

• Responsible for analyzing the current enterprise capabilities.
• Responsible for creating the new architecture for the Enterprise Data warehouse.
• Evaluate the business requirements for the Data and reporting needs.
• Responsible for defining the DW/BI roadmap and Technology.
• Responsible for creating the cloud architecture for the infrastructure.
• Responsible for creating the logical/physical models using the Sparx EA.
• Experienced with Big Data/Hadoop technologies.
• Responsible for creating the EA framework models for all business processes.
• Responsible for implementing the best practices/standards for managing the security across the organization.
• Responsible for managing the PHI/PII data.
• Responsible for implementing the Masking/Encryption solutions.
• Responsible for implementing the SOA for integrating various applications.

Confidential, Eden Prairie, MN

Data Integration Architect /Technical Architect

• Responsible for the Data Warehousing Architecture, Business Intelligence Architecture (Integration/Staging/Marts/Reporting).
• Responsible with implementing the standards, Best practices and ensures overall integration, compatibility and effectiveness of systems as part of the DW/BI Architecture.
• Experienced with Big Data, Hadoop (MapReduce, Hive, HBase etc.)
• Responsible for building/maintaining the Meta Data Management for all the Tables/files.
• Responsible for designing the DW/BI using the Data Virtualization (CISCO) to build the normalized and de-normalized structures.
• Experience with Big Data, Hadoop (MapReduce, Hive, HBase etc.)
• Experienced with setting up IBM MDM.
• Responsible for setting up the Security Architecture using ECG (Electronic Customer Gateway) and DRG (Data Release Governance) to send/receive the PHI/PII Data.
• Experience engaging and influencing senior business executives and senior IT executives.
• Responsible for Data Management, Data Governance, Data Quality, Data security, Data Audit, Data Masking, Data Modeling and Data archival process.
• Responsible for maintaining/managing the Infrastructure of Teradata, SQL Server, SSRS/SSIS/Cognos, and Storage etc.
• Responsible for integrating the data (Healthcare data) from various Source Systems (CMS, HEIDIS, FIN360 etc.)
• Responsible for building the Data Dictionary for the Source files, Data Marts and Reports.
• Responsible for creating the Interface Agreements (IA) with the Source systems. The IA should include the source file details, method of integration, schedule of delivery, Data Dictionary etc.

Confidential, RICHFIELD, MN

Solution Architect (DWH/Business Intelligence)

• Responsible for interacting with the Business Units to understand the business requirements and successful delivery of Solution Architecture for the EDW/BI Projects.
• Responsible for managing the team of Architects, Technical Leads, Developers, and Business Analysts with Offshore/onsite model. Responsible for coordinating with the Project Managers for the timely completion of the project (Analysis/Design/Modeling/Build/QA).
• Responsible for creating the various artifacts like Solution Blueprints, Level 2 Design Documents (L2D, L3D), and High Level Documents (HLD). Demonstrated the architecture solutions to the Enterprise IT Council, Architectural Governance committee, Directors, Sr. Directors etc.
• Responsible in setting up the MS BI Infrastructure (DEV/QA/STAGE/PROD) using the Share Point 2013, SQL Server 2012, SSIS 2012, SSAS 2012, SSRS 2012, and MDS 2012.
• Worked with Microsoft to setup the SQL Server PDW 2012. Implemented the Single Sign on (SSO) approach using the AD-FS etc.
• Responsible for converting the existing Reports (Crystal, BOBJ, and In House .NET) from Teradata to SSRS with SQL Server PDW. Completely rebuilt the Reports using SSRS/Share Point.
• Responsible to get the Data from various external source systems (Business Units) to the Staging Layer (Receiving) before integrating and consolidating for ODS purposes.
• Responsible for integrating the various external interfaces (App Talk, Informatica, Files, NAS, and MDS) with the EDW/BI Applications.
• Responsible for building the ODS Marts (using SSIS/PDW) to suite the Reporting requirements.
• Developed the Meta Data Management using the SQL Server MDS.
• Responsible for building the SSAS Tabular/Multi-Dimensional solutions for performance critical applications/reports.
• Responsible for building the operational reports using the SSRS 2012 and Power Pivot/ Power View (Self Service Capability).
• Responsible in conducting the Load testing and Web Testing using Visual Studio for testing the performance of Reports.
• Responsible in implementing the best Practices with EDW, Business Intelligence, Share Point Portal, TFS, ETL / Reporting.
• Responsible in setting up the Monitoring and auditing mechanism in place.
• Implemented the TFS for managing the source code and code promotion.

Confidential, Plymouth, MN

Sr. IT Database Consultant/Architect - Engineering

• Responsible for leading / mentoring the Operations/Project DBA’s to implement various Database solutions to support the Database environment. Responsible in implementing/upgrading the SQL 2008/SQL 2012 in the current environment.
• Implemented the Database Mirroring, Online Indexing, Data Compression, Virtualization and Encryption. Experienced with Database Design and Data modeling tools.
• Skilled in SQL Server hardware and configuration optimizations. Experienced in the planning, design, implementation, and operation of database systems.
• Experienced with building and supporting the TRICARE environment. Especially with implementing strict security measures based on NIST, STIG rules.
• Experienced with developing the SaaS, IaaS, PaaS (Platform as a Service), NGIS (New generation Infrastructure Services), and Cloud based environment.
• Experienced with creating the Standards and Standard Operating Procedures (SOP).
• Experienced in implementing operational automation using scripts.
• Experienced in design and development of OLAP functionality in Data Warehouse.
• Experienced with Share Point 2007 and 2010 for maintaining the content and Wiki sites.

Confidential, Plymouth, MN

IT Database Consultant

• Installed and configured SQL 2000/ SQL 2005. Upgrading the SQL 7.0/2000/2005 applications to SQL 2000/2005. Experienced with SAN, NAS devices and their upgrades. Supported and managed the Windows and VERITAS Clusters. Experienced with Database Management and tools.
• Responsible to support the Hundreds of Database instances and thousands of Databases with in the Database Services. Responsible for leading / mentoring the DBA’s.
• Played a key role to develop the Database projects for various types of applications and w orked with Wintel Admins, Network Admins, SAN Admins, System Engineers (SE’s), PM’s to successfully complete the projects.
• Provided various Disaster recovery solutions (Database Mirroring, Log Shipping, SAN replication etc.)
• Developed and implemented the solutions for various types of applications (ETL, BI and Web based). Experienced with Developing with Data Integration processes like Data Exporting, Data Mapping etc.
• Responsible for design, construction, testing, optimization, deployment, and operational support of reporting solutions using Excel power pivot to Share Point, SQL Server analysis services (SSAS) and SQL Server Integration Services (SSIS).
• Experienced with most of the ITIL modules like IT Service Management, Availability Management, Capacity Management, Continuity Management, Demand Management, Event Management, Problem Management, Incident Management, and Change Management.
• Designed/Deployed the SSRS/SSAS and SSIS (ETL) projects. Responsible for supporting the Critical applications like SharePoint.
• Responsible for the stability of the Environment and Improving the performance. Maintained almost 500 servers with 13000 databases and handling few TB of data.
• Experienced with handling the performance tuning, blocking and locking scenarios etc. Experienced with implementing the code promotions, Change Management, Incident Management, upgrading the Databases etc.

Confidential, Columbus, OH

IT Database Consultant

• Supported the Production Database environment with hundreds of DB Instances.
• Installed and configured SQL server 7.0, 2000/2005. Upgraded the SQL Servers from 7.0 to SQL 2000 and from SQL 2000 to SQL 2005.
• Performed the DR (Disaster recovery) tests using SAN replication / Log shipping / TSM restore.
• Applied Service Packs and Hot Fixes on Production/TEST/DEV SERVERS. Captured the Traces on the production servers to resolve performance issues. Migrating Access 97, Oracle Databases to SQL Server 2000.
• Experienced with developing the processes for Data Analytics applications. Experienced with Event Management, Problem Management, Incident Management, and Change Management.
• Created the Packages for executing the required tasks, jobs, alerts. Used AUTOSYS to schedule the SQL Server SSIS/DTS Packages. Maintained the BMC patrol for capturing the events from production SERVERS.

Confidential, Skillman, NJ

IT OLAP Consultant (BI / ETL)

• Responsible to support the Data warehousing Environment (ETL / OLAP).
• Responsible for developing Data Ware Housing, Business Intelligence solutions.
• Responsible for Source to Target mapping (STM), ETL processes using SSIS.
• Developed stored procedures and views using the SQL programming.
• Designed/developed various SSRS/SSAS and SSIS (ETL) projects.
• Designed/developed Dimensions, CUBES, and Virtual CUBES on Analysis Server (SQL 2000).
• Responsible for Performance tuning the source databases and target databases.
• Responsible for promoting the code between environments.

Confidential

Senior IT Manager

• Responsible for developing IT Architecture for a Web Portal. Involved in Planning, designing, coordinating / negotiating with vendors, defining the Policies / Procedures / Standards, hardware selection, software selection, designing reporting mechanism, designing ETL processes, designing Disaster recover solutions etc.
• Developed a strategic vision and strategy to position the organization to optimally meet the future needs of the businesses, ensuring alignment with Corporate/IT strategies, senior management, strategic business partners and key stakeholders.
• Responsible for managing internal customer relationships to ensure service levels are met.
• Responsible for data Architecture, data modeling and/or data management.
• Demonstrated the ability to lead, influence and motivate staff at all levels and to apply skills and techniques to solve problems. Conducted Staff Trainings and evaluated the performance of the Staff.
• Provided the status reports to Senior Management and Executive Staff.

Confidential

IT Manager

• Responsible for developing the IT Architecture for a Web Site using JAVA/ASP, Windows and UNIX. Involved in Planning, designing, hardware selection, software selection, designing ETL processes, designing Disaster recover solutions etc.
• Responsible for leading the team to develop the applications (Directory enquiry, and Billing enquiry) using JAVA/ASP, Windows and UNIX.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Served as a leader, mentor and motivated, inspired other team members.
• Experienced with developing the data mapping, ETL processes, and BI applications.