SUMMARY

• 20+ years of professional IT Consultant experience with PMP, Confidential , Microsoft SQL Server, ITIL s and Masters in Computer Science.
• 5+ years of ETL and data integration experience using Informatica, SSIS and SAP BW/BI.
• 10+ years of providing Data Modeling, Analysis and Business Intelligence Solutions using databases Confidential , SQL Server, MongoDB, Crystal Reports, Business Objects, ASP.Net, SSRS, SSAS
• Cloud solutions using AWS, AZURE.
• Expert in various aspects of software development, implementation, design, validation, project coordination and client interaction.
• Strong technical, analytical, and interpersonal communication skills to provide quality service and proven results.
• Excellent knowledge in Service Management, Incident Management, Problem Management and Change Management functions.
• Decisive team leader skilled in forming and leading high performing teams.

TECHNICAL SKILLS

• Data Warehousing Informatica Power Center 8.x, Workflow Manager, Workflow Monitor, SSIS, SSRS, SSAS, SAS
• SAP BW BI Platform, BI Suite - Business Explorer, Development Technologies, ODS Structures, Info Cube, Design Build
• Database Confidential , Sybase, Access, My SQL, MS SQL, MS SQL Server 2005/2008/2012 , Informix, DB2/400
• Business Intelligence SSRS, Cognos, Micro strategy, Crystal Reports, Business Objects XI

PROFESSIONAL EXPERIENCE

Confidential

IT Specialist Data Management

Responsibilities:

• Involved in working with Auditing System at Confidential .
• Solid understanding and Experience in cloud automation, technical design and implementations including IaaS, PaaS, and Saas.
• Involved in On-Premise migration of Microsoft SQL Server databases to Azure SQL.
• Application was using Azure load-balancing, API Gateway ensuring the availability.
• Used Key Vaults to store passwords and s.
• Implementation experience with Data Lakes, Data Bricks, Data Factory and Business Intelligence tools in Azure
• Experience creating Azure functions, Azure logic apps in Azure DevOps environment with CI/CD Pipelines.
• Experience in GIT based repositories.
• Exposure to Azure Storage(Blob/Data Lake Store).
• Experience with Azure Automation using Azure Resource Manager Templates.
• Familiarity with AWS IaaS, PaaS and Network offering
• Expertise in migrating applications from on-premises to Azure environments.
• Involved in design, develop and maintaining of CEAS databases, also involved in maintaining about 50schemas for supporting development, testing, user acceptance testing activities.
• Enforced coding standards and implemented code reviews, suggested process improvements and created and maintained documentation meeting the CMMI Level 3 standards.
• Worked on intensive archival process for the CEAS schemas to transfer the data from Archive to Nearline tablespaces which are eventually backed up to tapes.
• Produced project deliverables on time and within budget.
• Analyzed ongoing performance issues, worked on monitoring through OEM and producing AWR reports and identified the problem areas and suggested solutions to be implemented. Verify and tune SQL plans, queries as needed.
• Worked on new database development for storing the audit logs in CEAS and sending XML files of UNAX logs via EFTU to the SAAS(Audit Data warehouse). Involved in design, development, testing and support of this application enhancement.
• Monitoring production environment for password expirations, space issues, locked accounts, locking and unlocking users.
• Ensured compliance with data management standards. Recommended new or modified standards to increase efficiency.
• Performed a wide range of database administration functions, including running test queries, troubleshooting database problems, maintaining version control of database entities, advising customers on new database features.
• Worked on several ad hoc requests for data updates in the production environment.
• Generated complex queries and reports to meet the business requirements. Paid attention to detail, meeting customer service requirements, orally communicating effectively, solving problems based on the business requirements.
• Completed daily assignments with database knowledge and guided the team effectively.

Confidential

Sr. Database Engineer

Responsibilities:

• Designed, developed and maintained databases in Confidential . Worked on creating database and database objects for Carrier and Engineering Project which involved automating the metrics of carrier tasks. Major hands on experience developing data model, creation of objects, interpreting the requirements to mapping specs and defining the data rules and implementing them in Confidential .
• Data was replicated through the Confidential golden gate environment to the landing zone, then transferred to the staging zone. From stating the data was transformed using Informatica tool to the Core objects and semantic layer in the Data Warehouse environment. Spotfire is used to report data from the core objects.
• Expertise in Client-Server application development using Confidential 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Involved in Software Lifecycle processes from analysis, design, development, testing and implementation and maintenance with timely delivery against aggressive deadlines.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Used Confidential performance related features such as Query Optimizer, Execution Plans and Indexes.
• Developed data dictionaries, data models, meta data repositories, and other data management tools.
• Produced database design schema for integrating source data into data management systems.
• Participated in the design of data mining and data warehousing of systems.
• Experience in SQL performance tuning
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Confidential

Senior Database Engineer

Responsibilities:

• Managed a group of analysts that are responsible for performing strategic analysis to improve portfolio risk, profitability, performance forecasting and operational performance for mortgage (Countrywide) division.
• Hired, trained and led team members. Providing technical and business guidance to other database analyst and business users.
• Monitored progress and provided progress reporting to management.
• Designed and developed full scale reporting solution for Home Affordability and Modification Program (HAMP) in Confidential Mortgage division.
• Proficient in working with TSQL queries, stored procedures, views, triggers, indexes using complex joins and functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL Packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel sheets, flat files and OLEDB sources.
• Created Processes and Procedures to handle the Loss Mitigation Data and made it easily accessible for Reporting needs using SSRS.
• Created, implemented and maintained a reporting suite of over 50 standard reports while also customizing many reports to meet individual client needs.
• Created drill down, drill through, sub and linked reports using SSRS as well as managed the subscription of the reports.
• Generated multi parameterized reports allowing users the ability to make selections before executing reports; thus making them user friendly.
• Involved in the migration of SQL Server 2005 to SQL Server 2008 R2 64 bit Clustered environment. As part of the migration process did database backups, recovery and disaster recovery procedure.
• Involved in maintaining the SSRS reports on Share Point platform.
• Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries to retrieve data from cubes and also to display reports.
• Provided Reporting Solutions for tracking the HAMP process by creating Business, Quality Control and Exception Reports.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data and leveraged SSAS for analysis.
• Involved in leading the team in creating reports, managing the reports interface, automating the reports.

Confidential

DB Consultant

Responsibilities:

• Morgan Stanley, through its subsidiaries and affiliates, provides various financial products and services to corporations, governments, financial institutions, and individuals worldwide.
• The company operates in three segments: Institutional Securities, Confidential, and Asset Management.
• Created procedures, scalar and table defined functions to modularize the data retrieval process.
• Created ad-hoc queries from SQL Server 2005 databases for custom reporting needs.
• Involved in providing business reporting Solutions for Zenta Outsourcing of Loss Mitigation.
• Efficiently handled Loss Mitigation reporting needs and enhancements to existing environment.
• Led team in creating reports, managed reports interface, and automated reports.
• Involved in migrating databases from SQL Server 2005 to SQL Server 2008 R2 Clustered environment.

Confidential

Consultant

Responsibilities:

• Confidential Company engages in the design, development, manufacture, integration, and support of technological products, services, and solutions for governmental and commercial customers in the United States and internationally.
• Provided data models and data maps (extract, transform and load analysis) of the data marts and feeder systems in the aggregation effort.
• Designed, developed and implemented ODS Project.
• Populating ODS using a subset of existing extracts from Prism, APEX and BW
• Building and test the extraction and integration components.
• Support the developer base for the integration source and target systems in the coordination of integration tasks and dependencies.
• Work with other programmers, designers, and architects to make sure that the components meet integration requirements and performance goals.
• Conduct and participate in code reviews.
• Provide timely project status and escalate issues appropriately.
• Support unit, functional, system and performance testing of integrations.
• Fix any defects and performance problems discovered in testing.

Confidential, Dallas, TX

Lockheed Martin Consultant

Responsibilities:

• Lockheed Martin is a lead systems integrator and information technology company for the US Department of Defense, and the US Federal Government Agencies.
• As part of the Integrated Systems and Global Solutions team, provided services for Automobile, Retail and Investment domains.
• Led in analyzing, designing, developing, and implementing multi-tiered solution for TREES system designed to help Auditors in performing there tasks with Confidential taxpayers.
• Designed and developed n-Tier applications using .NET Win Forms for User Interface and component development of Business Tier Classes using C# in .NET Framework with SQL Server 2000 as backend database for custom rich-client solutions.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Responsible for extracting data from flat files and loading the data to the target database.
• Involved in maintain the RGS application through various yearly tax updates.
• Produced artifacts through out the software life cycle to meet the CMM standards. Used Rational methodologies and rational suite including Requisite Pro, Clear Case, Rational Rose, Clear Quest.
• Developed Use Case Models using UML and developed models in Rational Rose environment and identified the process flow of functionality.
• Worked on Confidential Clerk Manager System, Unattended Case Processing (UCP) designed using 3-tier architecture utilizing XML Web services at 3layers.

Confidential, Plano, TX

Lead Developer

Responsibilities:

• Designed and developed several web-based applications to aid in Document Management Process.
• Existing applications were converted to .NET Framework using VB.NET ADO.NET and ASP.NET on a Windows XP Platform using SQL Server 2000 database on back-end.
• Wrote workflow agents to do the processing both in NT and UNIX. Used Visual Basic in creating applications to assist in document processing. Created several ad-hoc reports using ASP, VBScript and Javascript with SQL Server 2000 and Sybase as backend databases.
• Maintained and supported Sybase database in addition to primary responsibility to SQL Server 2000 database including performance monitoring, fine-tuning, backup and replication.

Confidential, Plano, TX

Senior Database Developer

Responsibilities:

• Designed and developed several web-based applications to aid in Confidential Auto-finance functionality.
• Extensively used ASP, XML, MSMQ, SQL Server 2000, Visual Basic COM+ Components, HTML, VB Script and Java Script.
• Created Web Interfaces for Loan processing system that accepts Auto Loan Applications, processing them and sends financing decisions back to the Partner Company auto dealers. Data is received as XML files to our Load Balanced Web Server which does the Validation.
• An NT Service uses Components for Business Logic, processes them and stores them in SQL Server 2000 Database.
• Several jobs based on T SQL stored procedures are executed before the final decision is made and the decisions are sent back to the Partner Company.

Confidential, Plano, TX

Senior Developer

Responsibilities:

• Designed and developed data interface and reports for PLEXUS, which is a web-based application, designed using ASP, VB Script and SQL Server 7 as backend database.
• SQL Server Database Administration tasks such as installing and configuring SQL Server.
• Created Logical and Physical Design for the Plexus Application.
• Created NT and SQL Server authenticated user logins and roles, backing and restoring the databases, replicating data, creating and maintaining DTS jobs, Triggers, Views, Creating, Configuring and Scheduling user-defined jobs, performance monitoring and fine tuning of T SQL queries and stored procedures.

Confidential , Dallas, T exas

Consultant

Responsibilities:

• Designed and developed a Decision Support System (DSS) in Client Server environment. Sybase database resident on Confidential RS/6000 serves as the back-end to Graphical User Interface (GUI) developed using Visual Basic 3.0. Crystal Reports 4.0 is used to develop data aggregation and summarization reports .
• Installed, configured and maintained SQL Server 6.5.
• Extensively worked with Replication of the data between different servers and SQL Server stored procedures for data processing.
• Developed several applications using Visual Basic, Confidential, MS Access, Info Maker and Crystal Reports. Supported SAP implementation by developing reports using ABAP/4.

Confidential

Responsibilities:

• Modified and enhanced existing Packaging Room Management application used for Confidential products designed in Visual Basic using Confidential as back-end database.
• Wrote and de-bugged Confidential stored procedures, functions and packages.
• Designed and developed windows help for the application using Doc-To-Help.
• Provided technical support and acted as liaison between the users and help desk in baseline support issues.