SUMMARY:

• Over 15 years of wide range experience IT Manager and Architect, developer in Data warehouse Database Design, Database Development, managing of software applications to support reporting and Business Intelligence initiatives in Healthcare and Finance industries etc.
• Demonstrated strong strategic directions for the information system plan including technology development, deployment plans and departmental budgets
• Provided leadership for the IT department including planning of Information systems and development
• Managing the creation/maintenance of operational policies, procedures, standards, Guidelines and best practices
• Strong leadership skills and worked in matrix projects with application managers, project managers, developers and other team members
• Extensively worked on resource estimations and Budget allocations on ad - hoc projects and automation projects and Recruit, hire and train IT staff, developers and testers
• Strong skills in and Data Warehouse development and reporting technologies to the business needs
• Highly experience in conceptual, logical, and physical data modeling of Data Warehouse DW design and its implementation
• Extensively worked on setting up the Azure/cloud services servers and creating the databases and build the data marts and data warehouse.
• Extensively worked on server upgrades and migrations from legacy systems to newly created EDW environments
• Worked with best practices and highest level standards of compliance and integrity of Data Warehouse to improve the corporate environment
• Expertise in Database Fine Tuning, and indexing, File Groups and Object partitioning of Data Warehouse
• Played key role to development of Data Warehouse (DW), Data Marts, Operational Data Store (ODS) and reporting
• Knowledge of Data Warehouse database health checks and Transact log backups, Creating Frequent automatic Database backups by Database Maintenance Plans, and SQL Job agents, creating security User Logins, Granting User Privileges
• Hands on Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Strong communication skills and the ability to translate highly complex technical issues to non-technical audience and business users
• Proficient in creating the documents and presentations in Word, Excel, Power Point, Microsoft Project, Ervin and Visio
• Lead product release across various enterprise applications and The Agile processes and deliverables for the technical team and tune the workflow to ensure success
• Managing the IT trainings for IT staff members and end user training on ETL and reporting systems on architectural design development and best practices

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Manager IT PBM

Responsibilities:

• Responsible for IT Service Delivery for Operations and Annual Enrollment Project (AEP) applications
• Developed strategic direction for the information systems plan including technology deployment plans and departmental budgets
• Provided leadership and visualization for the IT department including premeditated planning of Information systems
• Managing the creation/maintenance of operational policies, procedures, standards, Guidelines and best practices
• Directing all information technology and network system migrations and deployment and maintenance including all mission critical applications
• Worked on resource estimations and Budget allocations on annual and automation projects, recruit, hire IT staff like analysts, developers and testers
• Creating financial forecasts, outline expenditures and modify budget when necessary
• Assessing new innovative technologies, mission critical systems, security, communications and business continuity
• Directing team in the areas of scheduling, technical direction, future planning and standard development practices
• Meets scheduled milestones to ensure project/program objectives are met in a timely manner and has an in-depth knowledge of the practices and techniques for managing the activities and their planning, managing and implementing projects and programs
• Demonstrated strong leadership skills and successfully worked in matrix project environment with other application managers, project managers, developers and other team members at onshore and offshore
• Responsible for ensuring the application architecture capable of supporting organization’s strategic goals
• Application development management and responsible for the delivery of suite of projects for every release
• Successfully completed Business Systems automation like Reconciliation Projects, Fulfillment Projects, Paper Claims projects, Coordination of Benefits Projects which involves compliances and adjudication process and reporting to CMS Government Services.
• Extensively worked on setting up the Azure/cloud servers and creating the databases and build the data marts and data warehouse.
• Extensively worked on server upgrades and Migrations from legacy systems to newly created EDW environments
• Worked with best practices and highest level standards of compliance and integrity of Data Warehouse to improve the corporate environment
• Managing required meetings with business users for gathering requirements and demo and deliverables for Paper Claims project
• Successfully completed paper claims projects which involves several heterogeneous Data Warehouse systems like T-SQL, Oracle, RxClaim AS400 DB2, Teradata, MS-Access Postgre-Sql and MySql
• Worked with DBA and other team members on establishing new environment such as DEV, TEST, and Prod for newly developed for Paper Claims project.
• Success fully completed several automation projects working matrix projects with other manages and under strict timelines delivered 110 SSIS packages in very short period
• Worked on universe parent-child packages, having complex of one parent package with up to 84 child packages
• Developed SSIS packages to store the clean data in the databases data marts and data warehouse by applying data validation, data clean up data scrubbing logics.
• Responsible to Conduct code review meeting for technical discussions and necessary changes
• Successfully completed on Coordination of Benefits (COB) projects and reporting systems
• Extensively worked on HPSM Tickets and to evaluate Root Cause Analysis (RCA)
• Successfully completed AEP projects like Reassignment, LIS Rider for manual and automated process
• Worked on Metrics & dashboard reporting on status of assigned applications which involves informative notifications, and responding the questions to the business users timely manner which involves the reports daily and 365 days reports and Annual Enrollment Period (AEP) and welcome seasons
• Successfully managed performance tuning of several RxClaim Legacy queries to drastic improve the execution time from 3.5-4.5 hours to 10-15 min results fast processing of reports and less manpower, working hours and cost
• Responsible for Data Warehouse development and reporting technologies to the business needs
• Worked on several conceptual, logical, and physical data modeling of for Data Warehouse DW design and its implementation
• Responsible for Data Warehouse development, data delivery, master data, across homogeneous and heterogeneous operational environments
• Worked with best practices and highest level standards of compliance and integrity of Data Warehouse to improve the corporate environment
• Managed Data Warehouse Database Fine Tuning, and indexing, File Groups and Object partitioning where they needed
• Managed Data Warehouse database health checks and Transact log backups, Creating Frequent automatic Database backups by Database Maintenance Plans, and SQL Job agents, creating security User Logins, Granting User Privileges and Access
• Worked on Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to translate highly complex technical issues to non-technical audience and business users
• Lead product release across various enterprise applications and The Agile processes and deliverables for the technical team and tune the workflow to ensure success
• Managed IT training for IT staff members and end user training on ETL and reporting systems and Trained colleagues on architectural design development and best practices

Confidential, Denver CO

SQL DBA Technical Manager

Responsibilities:

• Interacting with Clients and Project Directors to plan and execute the project provisions and work estimations and RFP's and leading on-shore and off-shore teams.
• Day to day roles and responsibilities such as Data Base Administration (DBA) like installation, Patching, Upgrades, Database Always On High Availability, Failover clustering, Database Restore, Disaster Recovery (DR), Mirroring, Log shipping and Transactional Replication.
• Extensively worked on all the versions Microsoft SQL Servers and Microsoft windows 2016 up to date.
• Installing the SQL Server database systems, maintaining the database systems includes to ensuring successful backups, resolving issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery etc.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Worked in Active-Active, Active-Passive Cluster environment as a High availability solution
• Database Fine Tuning, and indexing and Object partitioning, Database Troubleshooting activity and Script execution.
• Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Database Full and Transact log backups, Creating Frequent automatic Database backups by Database Maintenance Plans, and SQL Job agents, creating security User Logins, Granting User Privileges.
• Worked with the Systems Administration team, install and maintain Boardwalk approved application software and systems that integrate with Boardwalk's database systems.
• Migrating Databases from SQL Server 2000, 2005, 2008 to SQL Server 2008 R2 and 2008R2 to 2012 or 2014.
• Providing highly available database by Always on High Availability or Transact log backup and mirroring and application infrastructure according to Business Continuity requirements using SQL clustering, load balancing etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Responsible to Monitor and troubleshooting Log Shipping.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build process.
• Migrating application code and objects from development/test environments to production involving the DB Turnover process.
• All versions of SQL Servers

Confidential, Scottsdale, AZ

IT Project Manager

Responsibilities:

• Speaking to project directors and clients to find out what they want and initiate the proposal
• Developing strategic direction for the information systems plan including technology deployment plans and departmental budgets
• Demonstrated strong leadership skills and worked in matrix project environment with application managers, project managers, developers and other team members at onshore
• Advise clients objectively on where IT might make a difference to the business
• Planning the stages of the project and how each affects the business
• Coordinating the project team and assigning to the developers and analysts
• Agreeing costs, timescales and standards to be met and monitoring these through the project
• Conducting the code review meetings and adjusting the plans where needed
• Making sure there is a smooth change over from the old system to the new one and conducting the trainings to the business users
• Keeping management and clients updated on progress
• Responsible for getting the proper approvals for change requests and migrations.
• Worked on several conceptual, logical, and physical data modeling of for Data Warehouse DW design and its implementation
• Managed Data Warehouse database health checks and Transact log backups, Creating Frequent automatic Database backups by Database Maintenance Plans, and SQL Job agents, creating security User Logins, Granting User Privileges
• Responsible for coordination with QA UAT teams and monitoring SDLC and evaluation of each project stage

Confidential, Scottsdale, AZ

IT Application Manager

Responsibilities:

• Develop requirements, outlines, budgets, and schedulers for information technology projects.
• Responsible to oversee all phases of project from conception to completion.
• Suggesting new tools and software assist with upgrading information security
• Responsible to manage team of consultants, programmers, developers, and analysts.
• Ensure project is completed within budget and on time.
• Follow PMI standards to manage projects through the project lifecycles of initiation, planning, execution and closure.
• Develop work-breakdown structures.
• Develop project tracking and variance reports.
• Assemble risk management plans and work effort documents.
• Create project documentation.
• Provide risk assessment and alternates.
• Review estimates on cross matrix project proposals and sharing the project.
• Assess new opportunities and project possibilities.
• Prepared project proposals and responsible to getting approvals from the higher management.
• Flag potential issues and roadblocks.
• Manage multiple vendors and make sure that meet the SLA’s and TA’s.
• Utilize in-depth technical knowledge and business requirements to design and implement secure solutions to meet customer / client needs while protecting the corporation's assets.
• Develop security standards, procedures, and guidelines for multiple platforms.

Confidential, Chicago, IL

T-SQL BI Analyst Developer (Lead)

Responsibilities:

• Actively involved in the gathering requirements and analysis of the requirements related to the project.
• Extensively worked on production support, that includes Creating, Scheduling and Managing the SQL Jobs.
• Trouble Shooting the failed SQL Jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs
• Manually running some of the SQL Jobs which generates the Weekly, Monthly and Quarterly reports after making sure that the input data acquired or not.
• Interacting with Managers, Project Directors to plan and execute the project provisions and work estimations
• Using T-SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources (DB2, Access, Excel) to centralized T-SQL Server databases to overcome transformation constraints
• Extensively worked Design and develop SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute T-SQL Task.
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results Sets and Variables in SSIS as needed.
• Designed and executed packages which include direction of data flow, Column Mapping, Data dictionary and Metadata Flat file source and Flat file destination, OLEDB Source and OLEDB Destination using SSIS.
• Created package configuration in XML and used to deploy packages into T-SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Wrote backend code in ASP.NET and MVC4 to create desired Models/Views/Controllers Developed new Front-End Screens using ASP.Net.
• Responsible for the issues raised from the production and debugging and code deploying the updates of the front end website and dash board.
• Executed Analysis Services setup, tuning, cube partitioning, and dimension design including hierarchical and slowly changing dimensions.
• Worked on user defined hierarchies in SSAS including Parent-Child Hierarchy.
• Created and Configured OLAP Cubes using SSAS , Assisted in creation of T-SQL Server Analysis Services (SSAS) cubes for analysis.
• Created data sources, data source views, dimensions, measures, measure groups, key performance indicators (KPI), perspectives, partition aggregations. And deployment and processing SSAS objects.
• As part of Business Intelligence and Reporting team, played a key role in Development and Maintenance of SSRS Reporting Environment.
• Implemented complex Report Parameter on selection criteria that transformed and report performance for report retrieval.
• Was actively worked in all phases of development cycle of SSRS report conversion project. This conversion project was replacing the existing crystal reports and received accolades for rapid report development and deployment.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Designed and developed T-SQL codes for Tableau Reporting.

Environment: Microsoft T-SQL Server 2012/2008 R2, 2008, 2005, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.

Confidential, Tucson, AZ

Sr. Data Warehouse Developer

Responsibilities:

• Actively involved in the gathering and analysis of the rules and requirements of project.
• Involved in project scope, schedule planning and project impact assessments.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS.
• Performed query optimization for faster processing of queries, developed stored procedures, user defined functions, triggers, indexes and views.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Extensively used SSIS variables for storing the values, which are used in various components of Data Flow Task.
• Worked on execution of the paths depending on the success or failure of other tasks with precedence constraints to determine the workflow.
• Worked for performance tuning and optimization of T-SQL queries and indexes, automatic restart of SSIS packages after Failover or Failure.
• Used a variety of Data Flow Transformations, like Derived Column, Copy Column, Lookup, Data Conversion, Union All, Multicast and while developing the packages.
• Designed packages which are utilized for tasks and transformations such as Execute T-SQL Task, Data Flow Task, Data Conversion, Foreach Loop Container, Lookup, Aggregate, OLE DB Command.
• Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data.
• Scheduled package execution using T-SQL Server Management Studio to execute packages on a daily/weekly basis.
• Developed error handling routines for packages using both script tasks in the error handling tab.
• Created and configured OLAP cubes using SSAS, assisted in creation of T-SQL Server Analysis Services (SSAS) cubes for analysis.
• Wrote Documents test cases corresponding to business rules and other operating conditions and generated the Weekly Test reports about Test status and Defects summary.
• Created and developed customized reports to satisfy business needs using SSRS.
• Developed Reports with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports etc.).
• Created and Maintained documents to capture the different changes in SSIS packages.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to the Clients.

Environment: MS T-SQL Server 2008/2005, MS T-SQL Server Integration Services 2008, MS T-SQL MS T-SQL Server Reporting Services 2008, T-T-SQL, Windows 7, C#, SaaS and SharePoint.

Confidential, Baltimore, MD

T-SQL Server Developer/ BI Developer

Responsibilities:

• Interacted with business users for understanding and gathering business requirements and involved in project planning.
• Created SSIS packages for data integration from various data sources like Access, and T-SQL Server 2008 into the operational T-SQL Server and deployed them by using configuration tools.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Acknowledged the potential Issues that occur during the package execution by redirecting the rows from source components to the error output.
• Developed Stored Procedures, Triggers, Tables and Functions with T-SQL Server.
• Worked on maintaining the data integrity by performing validation checks.
• Maintained records in Excel Spread Sheet and exporting data into T-SQL Server Database using SSIS.
• Created user groups and accounts for users generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to designated Managers and Clients.

Environment: MS T-SQL Server 2005/2008, Server Integration Services 2005/2008, MS T-SQL Server Analysis Services 2008, MS T-SQL Server Reporting Services 2005, T-SQL, MS T-SQL Visual Studio 2005, Crystal reports, C#, T-SQL, MS Office and MS Access.