SUMMARY

• A successful IT professional wif over 15 years of experience serving both public and private sectors.
• Over 7 years of concentration in public health IT providing leadership and expertise in the design, development, and implementation of public health IT systems.
• Extensive experience in NOSQL Server Development, DBA, and ETL development, well versed in various phases of project development, testing, integration and maintenance or support.
• Data Loading Experience inSQL Server 2008using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Very good understanding of the Fact/Dimension data warehouse design model, including star and Kimball methodologies
• Experience wif working in AWS Cloud environment and understanding of AWS infrastructure.
• Well versed in software development processes and methodologies such as Agile, Scrum, CMMI.

TECHNICAL SKILLS

Languages: J2EE, JAVA, C++, .Net, Visual Basic

Database: Oracle10g/11, SQL Server 2008 R2/2014/2016, MySQL, T - SQL, PL/SQL

ETL Tools: Informatica, SSIS, Rhapsody, MIRTH

Testing-Tools: QuickTest Professional (QTP), LoadRunner, Selenium

Application/Web Servers: IIS (6.0, 7.0, 8.0), BEA WebLogic 11c, 12c, Tomcat 7/8, Apache 2.4

Version Control Management: CVS, Rational ClearCase. Subversion

Reporting Tools: SSRS, Crystal Reports, Tableau, Power BI

OS: UNIX, Linux, Windows 2008 R2/2012

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Create test sand maintain multiple MS SQL Server and No SQL databases and their models supporting platform.
• Manage all CRUD (Create, Read, Update, Delete) operations.
• Create, test and manage tables, views, stored procedures, table relationships, indexes, etc.
• Create and maintain documentation of data flow.
• Perform Extract, Transform, Load (ETL) processes for multiple data sources.
• Maintain normalized databases, manage transactions, and set up/maintain user permissions.
• Conduct database integrity checks and performance monitoring and tuning.
• Scaling databases such as replicants and shards.
• Ensure all databases meet required Federal encryption (in transit and at rest) standards.
• Manage backups, restore databases, and ensure disaster recovery.
• Oversee all aspects of SQL and NoSQL databases.
• Provided assistance on encryption and disaster recovery

Confidential, Buckhead, GA

Solution Architect/ SQL Developer

Responsibilities:

• As a Solution Architect worked wif Project Managers to configure and deploy customer solutions.
• Create test sand maintain multiple MS SQL Server and No SQL databases and their models supporting platform.
• Being a part of Deployment Services team me assessed the customer’s requirements and planed out the projects dat will deliver a working solution.
• Worked wif NoSQL to create needed store procedures, triggers to address the requirements as well as updated existing ones where needed.
• Coordinated wif the application development team working on .NET to provide them wif the necessary NoSQL objects.
• As a Lead DB developer me interact wif the customers to make sure the requirement are addressed effectively as part of development
• Configure and deploy integration components of customer implementations, including data mapping activities
• Worked wif existing customer to understand/analyzed existing setup and proposed solutions to address any new changes.
• Produce system/integration design documents in consultation wif internal stakeholders
• Maintain deployment documentation as products and customer configuration evolve
• Support Deployment Engineers during implementation of the system design
• Understands and adheres to Nexidia compliance standards, Corporate Compliance Policies, Code of Conduct and Conflict of Interest Policy.

Environment: Agile/Scrum, .NET, JSON, XML, Data Exchange Framework (SSIS), JIRA, Python, T-SQL, MS SQL Server, AWS, MS SQL Server MS, Confluence, PGP, VPC

Confidential, Atlanta, GA

Sr. DB Developer/ Sr. Data Analyst

Responsibilities:

• Performed data analysis on source system data to understand gaps, inconsistencies and other quality issues, and developed data quality improvement solutions
• Worked on improving the existing DB design and performance tuning some of the processes.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design
• Worked on multiple projects wif different business units and wif dealt wif customer so as to understand the requirements.
• Made use of one of the SQL Server security features of Cell-Level Encryption to mask the PII related information at DB level.
• Created various T-SQL scripts comprising store procedures, triggers, UDFs to address the requirements as well as updated existing ones where needed.
• Coordinated wif the application development team working on Java to provide them wif the necessary SQL objects as well as insight into the way data is being stored
• As a Lead DB developer me interact wif the customers to make sure the requirement are addressed effectively as part of development
• Developed ETL packages using SSIS, C#/.Net scripts.

Confidential, Atlanta, GA

Sr. DB Developer/ Sr. Data Analyst

Responsibilities:

• Created Data Architecture document for the project (NAMCS) outlining the usage of SQL Server Suite of tools as well as AWS
• Spun up AWS Virtual machines as per need for installation of various COTS Products.
• Involved in installation and configuring various version SQL Server and related suite of tools on AWS VMs
• Developed Schema design for Role based user access control as well modified the existing Registration DB Schema design
• As a Senior Analyst mentored junior members (3) of the team not only DB development best practices but also support related aspects of the assignment
• Understanding the existing customer setup and made modifications to the complex SQL workflow as needed to address the requirements directly in production environment..
• Worked wif Stakeholders, Solution Architects, Business Analysts and development teams across units to identify business needs and options.

Confidential, Atlanta, GA

Sr. DB Developer

Responsibilities:

• Designed and implemented DB component (Geyser Process implementation) on SQL Server 2008 R2 using SSIS Packages as a part of migrating in-house Legacy Verisign MPKI platform to the new offsite cloud based Symantec MPKI platform for issuing Client certificate.
• Deployed whole suite of Triggers to halp improve the notification process for PHINMS Support Team dat decrease the support validation effort by 30%
• Managed a team of three support engineers in troubleshooting issues encountered by the customers out in the field who implemented PHINMS software.
• Good knowledge in developing and designing reports throughSSRSandExcel
• Daily routine DBA tasks like handling user permissions and space issues on Production and Semi-Production servers.
• Developed Stored Procedures, UDFs, Views and Joins using T-SQL Scripting for implementing complex business logic.
• Successfully lead a team of five testers as part of testing the SQL server changes before being applied to Prod environment.
• Demonstrated Cloud readiness aspect of PHINMS software at PHI Conference
• Presented an overview of all the available functionalities of PHINMS for the end-users at PHI Conference
• Experience in data mapping, design, development, data gap analysis, implementation, testing, quality adherence, documentation, troubleshooting and customer support.
• Worked wif Confidential technical team (Agilex) and various Confidential jurisdiction during UAT testing before go live
• Actively supported the deployment of SSIS packages in all environments (Prod, Onboarding, Test, Staging)
• Worked closely wif ITSO/AHB team in deploying the Confidential related code on Linux based servers by following the Confidential change control process.
• Monitored the MIRTH channels, flow of messages, and Postgres DB and coordinated wif ITSO team and the sender jurisdictions to resolves any production issues.
• As a Lead support analyst, mentored junior member on the project setup and troubleshooting issues
• Was part of Tech Refresh effort involving Rhapsody, SQL Server upgrade for DMB
• Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular backup.
• Responsible for DMB data replay as needed.
• Worked closely wif Confidential Programs in identifying the messages which are updated and taking appropriate action to has changes updated on the receiver side.
• Monitored the DMB Rhapsody dashboard to validate the messages flow and verify against PHINMS count and Confidential message count
• Worked closely Confidential team in replaying the messages received via PHINMS as needed..
• Built trigger to catch the misrouted data and move to the messages to correct program (NND, PHLIP, Cancer registry etc.) table and send out notification
• Advised DB team on improvements to be incorporated into existing systems processes dat are in place which include but not limited to Data loading process involving SSIS for Confidential application.

Confidential, Atlanta, GA

Sr. Data Analyst/Sr. PHINMS Support Engineer

Responsibilities:

• Database (SQL server) validations (Back-End testing) were performed using SQL queries and SQL scripts, as part of H1N1 project, so as to ensure the data quality.
• Developed SQL scripts to automate the testing process of PHINMS software.
• Created Database tables and DB on MS SQL Server as part of functional testing for PHINMS.
• Assisted the Operations Manager in the Tech Refresh, a project involving upgrading of operating system (Windows ’03 to ’08), DB server (MS SQL Server ’00 to ‘08), application server (WebLogic 8.1 to 10.3) and PHINMS (v. 2.7.0 SP1 to 2.8.0).

Environment: Agile/Scrum, Java, J2EE, XML, AIX, Oracle WebLogic 8.1/10.3, Subversion, UNIX, Python, Informatica, C#, SSRS, AWS, Tableau, MS SQL Server, SSIS, MS SQL Server MS, JSON, JIRA, Confluence, GIT, RedGate

Confidential, Atlanta, GA

Sr. Data Analyst

Responsibilities:

• Involved in Back-End testing of the module TDS (Transaction Data Store, a Java base GUI), along wif numerous other Reports including GAL (Global Authorization Log).
• Database (Oracle based) validations (Back-End testing) were performed using SQL queries and PL/SQL scripts for reports and also data manipulation.
• Participated in the review of business functionality and interviewed business units/subject matter experts wif the objective of formulating business requirements and create Request for Proposals

Environment: C++, Java, Oracle 9i on Aix 5.2, HP Quality Center 9.2, TOAD, PL/SQL, Borland Caliber RM, QTP 10, In-house backend Emulators MERANT PVCS, Oracle APEX

Confidential, Atlanta, GA

Sr. Data Analyst

Responsibilities:

• Unit testing of SOAP/XML web services using SoapUI and validation of WSDL.
• Involved in testing various SQL jobs which make up the various business processes of the credit card system (viz., Credit Balance Refund, Balance Transfer, Alerts, and various Notifications).
• Involved in retrieving the data required for various web services testing from the database using SQL queries and scripts.

Environment: MS SQL Server 2005, SOAP/WSDL/XML web services, XPATH, SoapUI