SUMMARY

• Overall 24 years of industry experience, with 11+ years of experience leading IT projects in areas of Solution Architecture, MDM Architecture, Product Development, Database Architecture and comprehensive knowledge in database domain.
• Ability to deliver full lifecycle MDM projects for clients including Data modeling, Metadata management, Design and configuration of matching and merging rules, Design and configuration of standardizing, cleansing and deduplication rules.
• Excellent ability to articulate data management, metadata management, data governance, data quality concepts and liaison between Business and Technology teams.
• Formulate policies and guidelines for enterprise data governance.
• Interact with Business teams to understand the functional design and provide end to end data solution architecture.
• Ability to provide direction and specialist knowledge in applying the technology/application to client business.
• Experience in advising clients in complex project implementations.
• Ability to ensure operational policies are followed and business objectives achieved using best practices and process improvements.
• Managed individual contributors for overall success of project implementations.
• Knowledge of Agile & Waterfall methodologies and Software Development Life Cycle (SDLC).
• Knowledge of system analysis, system architecture, and systems engineering principles using TOGAF.
• Maintained detailed project plans including milestones, tasks, and target/actual dates of completion.
• Strong leadership skills and managed large & complex initiatives successfully.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Supervised and lead high profile oil & gas reservoir development and interact with clients for additional features beneficial for their overall reservoir planning.
• In the Financial industry, I have implemented projects where mortgage fraud is identified and reported, identification of growth stocks and bonds for institutional and fixed income investors, new and unique customers along with their insurance policies and claims.
• In the healthcare industry, implemented projects for uniquely identifying doctors, hospitals/clinics and identifying Medicare part D eligibility.
• Experience in the auto industry was the reworking of the sales site that included added features with customer usability with enhanced experience for user like ease in search of potential new and used cars as well as identifying potential vehicles for resale.
• Public trust security clearance for Federal projects. Involved in the master data implementation for the consumer product safety commission for products, industry/manufacturer, and safety issues domains.
• Experience in mentoring, guiding, and managing both onsite and offshore teams including managing budgets and resource allocation.
• Masters in Engineering Management, Masters in Petroleum Engineering, & Bachelors in Electrical & Electronics Engineering.

PROFESSIONAL EXPERIENCE

Confidential, Agoura Hills, CA

BI Architect

Responsibilities:

• Interacted with the business stakeholders to understand the needs, gather requirements and provide the technical solution for the digitization of customer interactions for all BOA products.
• Responsible for analyzing and architecting the data flows required for the various applications covering salesforce Sales Cloud and Marketing Cloud integration and sun setting of Siebel CRM.
• Responsible for architecting the compliance related applications.
• Added additional fact & dimension tables for compliance data.
• Created real - time data integration from Sales cloud & Marketing cloud using change data capture and merge records in data warehouse.
• Mentor team with the best practice implementation for projects.
• Lead implementation team and provide reviews of team members.

Environment: SQL Server 2016/2014/2012/2008 R2, SSIS, SQL Server Data Tools, Oracle 11G, Windows Server 2012, Salesforce Sales Cloud, Salesforce Marketing Cloud, Siebel, Informatica PowerCenter, Autosys, Erwin, Visio, Toad.

Confidential, Owings Mills, MD

Lead Data Warehouse Developer

Responsibilities:

• Interacted with the business to understand the needs, gather requirements and provide the technical solution for migrating from legacy time control system to Work Day.
• Provided guidance to design the appropriate data model for the implementation.
• Created data mapping and functional specification documentation based on the BRD.
• Designed and developed the ETL solution to load the Fact and Dimensional tables in the Data Warehouse for Type 0, Type 1 & Type 2 Slowly Changing Dimensions.
• Performance tuned the solution to provide an optimized implementation.
• Created Autosys jobs to execute the ETL jobs on a daily basis.
• Developed scalable and reusable ETL templates.
• Provided technical leadership to developers and conducted code reviews.

Environment: SQL Server 2014, SSIS, SQL Server Data Tools, Windows Server 2012, Microstrategy, Autosys, Azure.

Confidential

MDM Solution Architect

Responsibilities:

• Worked with business and IT stakeholders to understand the current state of information flow and source systems.
• Understand pain points, their root cause and other business drivers to develop a business case for Customer MDM.
• Developed a future state end to end conceptual and logical architecture including data models, data quality management and metadata management.
• Recommended Best Practices for Data Enrichment process.
• Presented strategic direction for the Data governance principles and procedures including Data Quality rules, Data Lineage and business glossary.
• Documented and maintained conceptual, logical, and physical data models, data dictionary and entity mapping documents.
• Responsible for enhancements and automation of existing processes to improve performance and reliability.
• Prepared the design for the HA DR plan for the Database environment.
• Responsible for Data Warehouse integration points and corresponding ETL components.
• Performed enhancements of existing applications and database systems, to ensure continued operations and improve data quality.
• Lead team with the development and implementation of projects.
• Ensured appropriate operational planning is effectively executed to meet business needs.
• Established a POC for MDM Customer and Product domains from the ground up using Informatica MDM.
• Evaluated various MDM Solution patterns (Repository, Hybrid).
• Designed and developed the Party Hierarchy Data Model.
• Integrated Policy and Customer data from Guidewire and MS dynamics (CRM) into the MDM Solution.
• Performed MDM product evaluations (Master Data Services and Informatica MDM) to determine the best fit MDM tool for Hartford Steam Boiler.
• Setup new Systems, Users Profiles, Lookups and Base Objects for a new database.
• Designed and developed Informatica MDM Mappings, Cleanse Functions and Cleanse List, Trust Configuration and Validation Rules, Match & Merge, fuzzy and exact match rules and setting up and tuning User Exit processes.
• Created beforesave, aftersave, beforemerge, aftermerge customized user exits in eclipse.
• Developed Queries and Packages and assigned them to various users (Data Stewards role) for use within Merge Manager and Data Manager.
• Configured & implemented approval workflows using activeVOS for Informatica MDM.
• Configured and implemented Informatica Data Director (IDD) i.e. Subject Area, Dashboard and Workflows.
• Performed Metadata Migration of MDM Change List from one environment to another to facilitate Informatica MDM code migration.
• Recommended Best Practices for Data Enrichment process.
• Performed Master Data additions, changes, and deletions in accordance with established procedures and business rules; Responded to Master Data information requests; Investigated data related issues to provide timely and productive solutions.
• Acted with data stewards to define and maintain data dictionary.
• Worked with other IT teams to investigate data-related problems in down-stream applications.
• Corrected data flagged on data integrity reports/dashboards.

Environment: SQL Server 2014, Oracle 11g, SSIS, SQL Server Data Tools, Windows Server 2012, GuideWire, MS Dynamics, SAP DQ, SAP Info Steward, SAP MDM, Informatica MDM 10.1, Multi Domain MDM, Customer 360, Product 360, Metadata Manager, Hierarchy Manager, Merge Manager, Workflow Manager, ActiveVOS, JBoss, SIF, SoapUI, Powercenter, IDD, IDQ.

Confidential, Redwood City, CA

MDM Architect

Responsibilities:

• Responsible for Master Data Management and maintenance of customer data.
• Responsible for the Architecture, configuration and support for the MDM implementation for Master Data for Confidential .
• Experienced in working with Veeva, Concur, and Oracle ERP.
• Implemented MDM processes and standards in order to maintain and improve customer master data accuracy, completeness, and timeliness.
• Supported data stewardship and governance for key enterprise initiatives.
• Excellent understanding of customer master data domains in pharmaceutical/bio-tech environment.
• Experienced in integrating new data sources with existing master data management system, identifying and fixing data discrepancies, reading and translating data models to make additional improvements.
• Performs Master Data additions, changes, and deletions in accordance with established procedures and business rules; Responds to Master Data information requests; Investigated data related issues to provide timely and productive solutions.
• Act as data steward to define and maintain data dictionary.
• Worked with other IT teams to investigate data-related problems in down-stream applications.
• Corrected data flagged on data integrity reports/dashboards.

Environment: SQL Server 2014, Oracle 11g, SSIS, SQL Server Data Tools, Informatica MDM 10.1, Metadata Manager, Hierarchy Manager, Merge Manager, Workflow Manager, ActiveVOS, JBoss, SIF, SoapUI, Powercenter, IDD, IDQ, Windows Server 2012, Windows Server 2008, .Net, Team Foundation Server 2012, Veeva.

Confidential, South San Francisco, CA

MDM Architect

Responsibilities:

• Responsible for the architecture, design and operations of strategic enterprise MDM initiative to consolidate data from different business units and external sources for the master data.
• Well experienced in determining the technical and business requirements, architecting, designing, and creating technical solutions to fit the business needs.
• Designed and implemented the solution for analyzing and designing data cleansing and de-duplication process for MDM.
• Well experienced in using IDQ to set up a data quality mechanism to ensure that only fit for purpose data reaches the MDM solution and the downstream systems.
• Designed and implemented Informatica PowerCenter interfaces from MDM solution to provide data to downstream system.
• Worked with multiple teams that are directly and indirectly connected to MDM Hub to identify and resolve issues and identify enhancement needs.
• Performed data profiling and data analysis to study, understand and monitor quality of data.
• Experienced in performance tuning and troubleshooting of the MDM Solution.
• Performed planning and implementation of software installation and configuration activities.
• Advised, oversaw, and mentor team members.

Environment: SQL Server 2014, SQL Server 2012, Informatica MDM 10.1, Metadata Manager, Hierarchy Manager, Merge Manager, Workflow Manager, ActiveVOS, JBoss, SIF, SoapUI, Powercenter, IDD, IDQ, SSIS, SQL Broker, SQL Server Data Tools, Windows Server 2012, Windows Server 2008, .Net, Team Foundation Server 2012.

Confidential

MDM Architect/Database Architect/DBA

Responsibilities:

• Documented and maintained conceptual, logical, and physical data models, data dictionary and entity mapping documents.
• Responsible for the creation and maintenance of Data Governance Policy document and Metadata registry.
• Designed and implemented the Master Data Services Objects and Entities.
• Architected solution for messaging between applications using SQL Broker.
• Responsible for implementing data encryption using transparent data encryption (TDE) in order to maintain the regulatory compliance and corporate data security standards.
• Designed and developed ETL integration between SQL Server MDS Services and several downstream applications as per the business requirements.
• Performed enhancements of existing applications and database systems, to ensure continued operations; improved efficiency and performance, address new user requirements, and add new functionality.
• SME for the migration/upgrade of Master Data Services (MDS) 2008 to MDS 2012.

Environment: SQL Server 2012, SQL Server 2008 R2, MDS 2012, MDS 2008 R2, SSIS, SQL Broker, SQL Server Data Tools, Data Quality Services DQS, Windows Server 2008, Windows Server 2003, .Net, Team Foundation Server 2012, Azure.

Confidential, Santa Monica, CA

Senior SQL Server Developer/Senior SQL Server DBA

Responsibilities:

• Responsible for analyzing and architecting the data flows required for the Equity and Fixed Income analytical solutions.
• Responsible for enhancements and automation of existing processes to improve performance and reliability.
• Prepared the design for the HA DR plan for the SQL Server environment including setting up mirroring and replication across instances.
• Worked with the Business on Reporting Requirements and Designed and developed reports per requirements.
• Proposed technical options and recommendations for addressing data quality issues.
• Assisted Project Management team on schedule and risk planning.

Environment: SQL Server 2014, SQL Server 20142, SSIS, SQL Server Data Tools, Windows Server 2008, Windows Server 2003, .Net, Team Foundation Server 2012.

Confidential

Master Data Services Architect

Responsibilities:

• Responsible for Data Warehouse integration points and corresponding ETL components.
• Performed enhancements of existing applications and database systems, to ensure continued operations and improve data quality.
• Implemented the data quality initiatives to support the datagovernance processes.
• Implemented the Integration of Data Quality tool (DQS) with the MDM tool (MDS) to spearhead the implementation of data governance (de-duplication, aggregation, re-conciliation, archiving).
• Collaboratedwith the Subject Matter Experts to create the data dictionary (Meta data Repository)and to create the data cleansing rules and metrics.
• Supported the generation/validation of Data Governance Metrics using the DQS tools.
• Responsible for identifying integration points with other Confidential applications and make necessary changes, including code, scripts, configuration, data, and databases including integrated Data Repository to ensure no negative impact to users.
• Responsible for Systems integration and data exchange between Confidential Systems via Data Repository (SQL Server 2008 R2 MDS/SSIS) and SQL Server Services Broker.
• Responsible for enhancements to ETL Packages required for implementing the Data Governance processes in the MDS solution.
• Held regular stakeholder prioritization meetings, record outcomes and work with the customer, technical leads to recommend options and schedule.

Environment: SQL Server 2012, SQL Server 2008 R2, MDS 2012, MDS 2008 R2, SSIS, SQL Broker, SQL Server Data Tools, Data Quality Services DQS, Windows Server 2008, Windows Server 2003, .Net, Team Foundation Server 2012, Azure.

Confidential, Los Angeles, CA

Database Architect

Responsibilities:

• Prepared the as-is and to-be process flows for the data.
• Defining, designing, executing, accessing, operating, and maintaining of master data.
• Responsible for defining and modifying the business processes that will be supported by the MDM discipline.
• Defining ownership/stewardship of master data.
• Defining data governance policies, responsibilities and rules.
• Measuring compliance on data governance policies.
• Point of contact for on all backend related activities for CRM Datamart project.
• Responsible for the design and enhancements of schemas, stored procedures, functions, triggers, referential integrity, security and other database constructs.
• Plan and implement the migration and consolidation of SQL Instances for reducing Microsoft Licensing cost.
• Design and develop Cloud SQL backups to AWS (Amazon Web Service) using Fast Glacier and CloudBerry tools.
• SME for the migration of reporting environment (SSRS) from SQL 2008 to SQL 2008 R2.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Manage offshore DBA team project allocation.
• Provide on call production support when needed.

Environment: SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000(SQL Server Management Studio, SQL Server Agent, Activity Monitor) SSIS, SSRS, SSAS 2008R2, Windows Server 2008, Windows Server 2003, .Net, Team Foundation Server 2012, Team Foundation Server 2008, GIT, AWS S3.

Confidential, Calabasas, CA

BI Developer/Application DBA

Responsibilities:

• Interacted with the business to understand the needs, gather requirements and provide the technical solution.
• Responsible for analyzing and architecting the data flows required for the various applications covering fraud detection, violations, remediation, referrals, and stop funding alerts for new loans.
• Responsible for architecting the BI environment including sizing and capacity planning.
• Provided guidance to design the appropriate data model for the implementation.
• Designed high availability & disaster recovery environment for data warehouse.
• Designed the ETL solution to load the Fact and Dimensional tables in the Data Warehouse for Type 0, Type 1 & Type 2 Slowly Changing Dimensions.
• Implemented data encryption and data access management for ensuring regulatory/compliance requirements.
• Mentor team with the best practice implementation for projects.
• Lead implementation team and provide reviews of team members.

Environment: SQL Server 2008, SQL Server 2005 (SQL Server Management Studio, SQL Server Agent, Activity Monitor,) SSIS, SSRS, Nexus, Windows server 2008, .Net, Team Foundation Server.

Confidential

Database Architect/SQL Server DBA

Responsibilities:

• Virtualized and consolidated SQL servers to reduce cost.
• Reduced foot print.
• Reduced power consumption.
• Better manageability.
• Optimized databases to improve efficiency, remove data redundancy.
• Architected and implemented the Master Data Management system using the new SQL Server 2008 R2 feature - Master Data Services.
• Architected and implemented the SQL server administration and monitoring system using the Control Point Utility.
• Architected and implemented the database archiving process.
• Designed and developed SSIS packages for loading & transforming data.

Environment: SQL Server 2008 R2, SQL Server 2005 (SQL Server Management Studio, SQL Server Agent, Activity Monitor, SQL Server Profiler, Database Engine Tuning Advisor, SQL Server Configuration Manager, Performance Monitor, Utility Control Point, Master Data Services) SSIS, SSRS, SQL Server 2000 (Query Analyzer, Enterprise Manager, DTS Designer) Windows server 2008 R2, Litespeed, Visio 2007, Clarity, Windows server 2000, Windows server 2003, .Net, Cold Fusion, IIS, VMWare, VSS, Team Foundation Server, AccessDatabaseEngine X64, dtsxchange.

Confidential

Database Architect

Responsibilities:

• Performed the analysis, scoping and estimation of the project based on the requirements gathered from the business users.
• Responsible for database architecture, design of database objects and infrastructure design.
• Devised plan for High Availability, Load Balancing and Disaster Recovery strategies using transactional replication and database mirroring.
• Assisted in the software licensing and hardware requirements initiatives.
• Provided solution strategies to the application developers for implementing the presentation & business logic.
• Developed logical database design using data modeling tool Visio 2007 and the database design.
• Provided guidance to the offshore development team on the best practices and key database design decisions.
• Designed and guided the development of:
• SSIS packages to migrate data from Access 95 to the new SQL Server 2008 environment.
• Functional as well as administrative reports using SSRS 2008.
• Database maintenance plans and execution.
• Transactional Replication for high availability and load balancing.
• Review and oversee offshore development effort and in-house software testing.

Environment: SQL Server 2008 (SQL Server Management Studio, SQL Server Agent, Activity Monitor, SQL Server Profiler, Database Engine Tuning Advisor, SQL Server Configuration Manager, Source Control Services, Replication Monitor, Performance Monitor) SSIS, SSRS, Windows server 2008, Visio 2007, Remedy, Windows Server 2003, .Net, Access 95.

Confidential, Philadelphia PA

Senior SQL Server Developer/DBA

Responsibilities:

• Supported SQL Server 2000/2005 production, staging and development servers.
• Designed and developed in-house monitoring system using standard SSIS packages that captures system data for: success or failure identification of scheduled DBA jobs like backups, reindexing, updating statistics. alerts generated for disc free space, SQL Agent Restarted, tempdb being full and msdb log getting full.
• Upgraded all monitored SQL Servers to the latest Service Packs (SP4 for SQL Server 2000 & SP2 for SQL Server 2005).
• Performed SQL Server upgrade from SQL Server 2000 to SQL Server 2005.
• Installed SQL Server 2005 (Database engine and Analysis Services) in a 64 bit environment along with the addition of 64 GB memory.
• Assigned as the person of contact for all support for the “Spotlight” business group.
• Performed regular audits for orphaned users, maintained standard packages and the version updates of all the packages, users’ rights in production databases and other regular DBA standards for team service accounts.
• Developed SSIS packages for generating the Performance Matrix for indexes, Growth Projection for all databases on all production servers, and generated reports for the same.
• Activated server level and database level triggers to track all changes made to the production servers by the business.
• Performed in-place upgrade from SQL Server 2000 to SQL Server 2005.
• Performed SQL Server 2005 installation with SP2 upgrade on standalone as well as clustered (A/P & A/A) servers.
• Developed standard SSIS package for backing up databases based on various groups that are called in jobs with set values.
• Designed jobs for backing up very large databases (>1TB) into multiple backup files.
• Provided daily support for creating logins, provide various level of permissions, backup and restore databases, blocking and locking issues, performance tuning of stored procedures and queries.
• Utilized Computer Management system tools such as Performance logs and Alerts and Local users and groups and Computer Management Storage tool like Disc Management.
• Performed realignment of SAN discs and addition of SAN disc space for managing the disc drives in a clustered environment.
• Utilized separate files and file groups for data and log files.
• Configured jobs to automatically push production changes at scheduled time.
• Designed and developed peer to peer replication for efficient and load balanced operations.
• Provided the management with all day to day activities and also a consolidated weekly update for all ongoing projects and activities.
• Interacted with various business groups to plan out for any new projects and also on milestones for ongoing projects.

Environment: SQL Server 2005 (SQL Server Management Studio, SQL Server Agent, SQL Server Profiler, Performance Monitor, Database Engine Tuning Wizard), SQL Server 2000 (SQL Enterprise Manager. SQL Query Analyzer, SQL Server Agent), SQL Server 2008, Windows Server 2003, Windows Server 2000.

Confidential

Senior SQL Server Developer/DBA

Responsibilities:

• Responsible for supporting & maintaining company’s SQL Server databases(2005 & 2000) including managing the production and development databases, capacity planning and database security configuration.
• Managed SQL Server logins and user accounts/passwords and service accounts/passwords including database object permissions.
• Configured and scheduled maintenance plans for backing up data files and transactional logs.
• Scheduled regular database consistency checks, index defragmentation and rebuild indexes.
• Migrated databases from MS SQL server 2000 to 2005 using the upgrade advisor results.
• Implemented structure and data changes.
• Modified stored procedures and DTS packages according to the database changes made.
• Responsible for applying service packs and hot fixes on SQL Server 2000 & SQL Server 2005 machines.
• Troubleshoot report failures, documented the findings and implemented appropriate solutions.
• Managed 20 SQL Server instances, each containing more than 15 databases with 500 GB to 1.5 TB data.
• Evaluated third party tools for database administration.
• Provided technical support to internal developers.
• Utilized various performance monitor counters (CPU, memory, processor, system, SQL Server database, SQL Server Buffer manager, Physical Disc and SQL Server Locks).
• Created baseline performance data and implemented monitoring and alerting mechanism to monitor deviations from the baseline.
• Prepared and maintained design and specification documentation.
• Interacted with the Director of Application and development, senior Application Manager and Senior Application Developers for trouble shooting linked server issues and DTS packages.

Environment: SQL Server 2005 (SQL Server Management Studio, SQL Server Agent, SQL Server Profiler, Performance Monitor, Database Engine Tuning Wizard), SQL Server 2000 (SQL Enterprise Manager. SQL Query Analyzer, SQL Server Agent), Windows Server 2003.

Confidential, Atlanta, GA

Senior SQL Server Developer

Responsibilities:

• Lead the migration of databases from MS SQL server 2000 to 2005.
• Responsible for MS SQL Server 2005 Installation and configuration as well as applying service packs and hot fixes.
• Used various DBCC commands to identify & mitigate resource constraints on the server (CPU, I/O, memory, tempdb bottlenecks)
• Evaluated and implemented data storage considerations to store databases and transaction logs.
• Planned and implemented backup and restore plans.
• Set up disaster recovery site in geographically different location using mirroring.
• Created baseline performance data and implemented monitoring and alerting mechanism to monitor deviations from the baseline.
• Configured and audited SQL Server security; managed SQL Server logins and user accounts/passwords; managed database object permissions.
• Designed and developed DTS Packages for importing data from various client database as Text file, db2, foxpro and SQL Server 2000 to SQL Server 2005.
• Carried out complex VB Scripting and lookups to select required data from non-uniform record sets.
• Implemented error handling in DTS Packages to capture erroneous records into a separate file.
• Designed datamart with functional tables for efficient report execution and created SSIS/DTS packages for data load from OLTP to OLAP system.
• Optimized the stored procedures and user defined functions used by SSRS for better report performance.
• Provided the functionality of ad-hoc reporting using SSRS as per business needs.
• Designed and developed SSIS packages to extract data from various data sources such as Text file, db2, foxpro and SQL Server 2000 for loading into SQL Server 2005 database.
• Used Upgrade Advisor prior to Migrating existing DTS packages to SSIS and modified the packages accordingly.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
• Prepared and maintained design and specification documentation.
• Interacted with the Project Manager and Application Developers for the on time and successful implementation of the TEM Application.

Environment: SQL Server 2000 (SQL Enterprise Manager, SQL Query Analyzer, SQL Server Agent, DTS Designer, DTS Wizard, DTS Package, Import/Export Data, VB Script), SQL Server 2005 (SQL Server Management Studio, SSIS, SSRS), ftp server, Windows Server 2003, PowerBuilder 10.5.

Confidential

Senior SQL Server Developer

Responsibilities:

• Designed and created database logical and Physical Schemas.
• Denormalized tables for Datamart to support CARDS & AMS Applications for faster report generation.
• Loaded Datamart (OLAP) using DTS package from the OLTP system.
• Created complex Stored Procedures using Dynamic TSQL for various functional scenarios (Patient Eligibility, Financial Review, Risk Change, Statistical Calculations etc.).
• Created store procedures and user defined functions for handling Patient Data with sort, paging, and random selection features.
• Incorporated the ability to generate ad-hoc queries by application user using dynamic sql, for ad-hoc reporting.
• Storing documents in different formats (.doc, .pdf etc) within the database and retrieving on request.
• Created database backup and restore plans.
• Configured the SQL Express clients (Auditor’s Laptop) and the SQL Server 2005 to use merge replication in order to synchronize offline data changes on the clients to the server.
• Created rule sets to resolve data conflicts during data replication.
• Created and configured SSIS package to be run as a job when it is called by a Stored Procedure. This is done to load the local database with data from multiple audits (average of 1 million rows).
• Interfacing with the application development team to review/approve/develop and implement all database changes.
• Responsible for the creation of the following objects (Databases, Tables, Indexes, Views, Triggers, RI Constraints, Infrastructure related Stored Procedures).
• Upgraded from existing MS SQL Server 2000 to MS SQL Server 2005.
• Involved in Design, Implementation, of highly available clustered SQL Server (2000) with SAN for shared data across the nodes.
• Migrated SQL Server 2000 to new hardware (Dell Hardware) - a clustered system.
• Monitor MS SQL servers (2005 & 2000) for errors and performance degradation.
• Set up WMI alerts, operators, SQL Mail, Database Mail, and notifications.
• Set up and schedule jobs, create Maintenance Plans to perform databasestructure checks.
• Configured users, roles, and privileges for the Application users.
• Prepared and maintained design documentation.
• Interacted with the management and Application Developers for the on time and successful implementation of the CARDS/AMS Applications.

Environment: SQL Server 2005 (SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Agent), Windows XP, Microsoft Visual Studio 2005, Visual C#, XML, Microsoft Visual Source Safe, Visio 2003.

Confidential, Philadelphia PA

SQL Server DBA/Developer

Responsibilities:

• Carried out performance tuning using Windows Performance Monitor, SQL Server Profiler, Index Tuning Wizard and Query Analyzer tools.
• Used SQL Server Profiler to trace the slow running queries and server activity.
• Used Trace templates trace file, for reusability.
• Used the SQL Profiler trace as input to the Index Tuning Wizard.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Used the Index Tuning Wizard periodically to determine the usage over time and determine on the optimal indexes for the databases how it is actually used.
• Analyzed locking and blocking issues in the production environment and carried out remedial steps.
• Performance tuned TSQL code using SQL Query Analyzer.
• Used DMV and DMF for diagnosing & troubleshooting performance issues.
• Used the graphical execution plan detailed information to trace the Query Optimizer during execution.
• Used Client Statistics to compare efficiency of multiple queries.
• Used Windows Performance Monitor to monitor both Windows 2000 and SQL Server 2000 performance.
• Created indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Identified and replaced inefficient table joins in reporting queries.
• Tuned the database structure by normalizing them.
• Optimized SQL queries for efficiency and assisted the front end developer with their queries and procedures.
• Created views to reduce apparent database complexity for easier and efficient report generation.
• Partitioned databases for faster data retrievals.
• Involved in Design, Implementation, and Documentation for Successful Migration/Upgrade strategy in a clustered SQL Server 2000 SAN environment.
• Migrated SQL Server 2000 to new hardware (Dell Hardware) a clustered system.
• Created Standard Operating Procedures (SOPs) and Work Instructions (WI) for SQL Server install, upgrade, apply patch and SQL clustering.
• Implemented Log Shipping to move the database to another server at regular intervals.
• Provided User Access at all levels for both the network and the SQL Server databases; configured and audited SQL Server security; managed SQL Server logins and user accounts/passwords; managed database object permissions.
• Prepared documentation/scripts for all stored procedures and tables and maintained technical documentation for operational support.
• Executed integration testing and load testing on IT and staging environment before applying on production.

Environment: SQL Server 2000 (SQL Enterprise Manager. SQL Query Analyzer, SQL Server Agent, SQL Profiler, Index Tuning Wizard), Windows 2000, PeopleSoft 8, Crystal Reports 11, Clarity.

Confidential

Well Test Supervisor/Data Specialist

Responsibilities:

• Responsible for Real time Surface and Downhole Data Acquisition operations for extended well testing in exploratory gas wells.
• Provide client with real time trends and analysis of Well Testing operations.
• Troubleshoot operations related issues and work with field personnel to develop long term solutions.
• Implement projects to improve field operational capabilities in the areas of:
• Marketing support.
• Quality Assurance.
• Client interactions.
• Provide mentoring and guidance for junior Field Engineers.

Confidential

Well Test Supervisor/Data Acquisition and Interpretation Specialist

Responsibilities:

• Supervised multidisciplinary team carrying out Well Testing and Surface and Downhole Data Acquisition operations.
• Performed Validation and Interpretation of field data for reservoir performance.
• Prepared and generated Well Testing reports for client presentation.
• Interacted with clients for the well test operations from the designing stage upto project closure.
• Provided operational and technical support to teams carrying out field operations.
• Implemented the Safety Action Plan for the Schlumberger Base.
• Conceived and compiled Training Manual for Well Testing Field Operators.
• Mentored Junior Field Engineers and Field Technicians.
• Managed and maintained Early Production Facilities and provided daily client reports for production status updates.
• Maintained good Client Satisfaction Reports through above expected standards in project execution.
• Expertise in Well Testing operations of
• HPHT gas wells with high H2S concentration.
• LPHT, high flow rate oil wells with high H2S concentrations. il wells using N2 lift method. il wells using down hole pumps.
• Data Acquisition from Surface Well Testing Equipment as well as Downhole Electronic data recording tools used in Well Testing operations.