SUMMARY

• More than 10 years of experience as a Database Analyst, Database Administrator and Programmer Analyst.
• Highly analytical and process - oriented data analyst with in-depth knowledge of database types. Installed, Upgrades, Configured and tuned Relational databases & RDBMS.
• Designed, developed, and integrated software to incorporate a wide range of applications and technologies.
• Conversant with full SDLC (Agile/Scrum), from gathering business requirements, writing specifications, coding, testing, and deploying across diverse industry domains.
• Knowledge of setting up a network or other system and experienced in performing maintenance on a regular basis.
• Extensive familiarity with raw and processed data and analytical experience. Domain knowledge of Healthcare (HIPPA, EHR & HIM), Accounting, eCommerce & Inventory Management.
• A candidate ready to utilize years of experience in IT to excel in any position.
• Hands - on technical expert in SAP BOBJ Reporting, BOBJ Data Services ETL process, Tableau, SQL/PLSQL, SAP BW, SAP HANA, Xcelsius, Crystal Reporting, and R programming.
• Interact with non-technical end user and Management to understand business logic
• Designed conceptual, Logical and Physical database model based on the requirement
• Discussed the Data model, data flow and data mapping with the application developers
• Designed, developed, deployed, Monitored and Tuned relational databases
• Developed ETL and ELT scripts to enable weekly/monthly processing of data sets into data warehouse.
• Communicated information about creating CDISC-compliant datasets
• Worked on Machine Learning R programming for Home Service Provider project.
• Interact with upper management to discuss and understand complex data analysis and generate analytical MIS and KPI reports using Power BI and Crystal reports
• Analyze and evaluates complex data to identify trends, variances, and problem areas
• Expertly created and developed highly complex stored procedures, functions and triggers applying to complex business scenarios to support various parameterized reports
• Proficient SQL Programmer with in-depth knowledge of Transact-SQL (DDL, DQL, DML, DCL, TCL) sed Python and R for programming for improvement of model. Upgrade the entire models for improvement of the product
• Developed business intelligence solutions for all business areas including: operations, accounting, marketing, ecommerce, Inventory management and executive management
• Proficiently transcribed Crystal reports for MIS, KPI and data analytic reports,
• Maintains existing Crystal Reports against legacy system and modifies/rewrites as per new requirements
• Write reports to print on Insurance Claim forms, postcards and on pre-printed forms and stationery using Crystal reports and VB 6.0

Technical Skills

Programming Language: PHP, Python, SQL, PL/SQL, C, C++, VB.Net, Visual Basic 6.0

Database: MySQL, ORACLE, SQL Server, MS Access, MongoDB

Report Writer: Crystal Report, Power BI, MS Excel

PROFESSIONAL EXPERIENCE

Database Analyst / Lead Programmer Analyst

Confidential, Fort Washington PA

Responsibilities:

• Designed conceptual, Logical and Physical database model based on the requirement
• Interacted with non-technical end users to understand the business logics
• Maintain database security and user privileges to protect data.
• Creating data reporting processes from start to finish; this includes data mining, analysis and reporting
• Ensures the integrity and accuracy of the data. Identifies data variations at data capturing event and suggest proper validation to application developers
• Converted clinical study datasets to conform with CDISC/SDTM standards
• Interact with non-technical end user to understand business logic, Discuss data flow and reporting requirement and work with application developers to generate reports.
• Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.
• Interact with upper management to discuss and understand complex data analysis and generate analytical MIS and KPI reports using Power BI and Crystal reports
• Analyze and evaluates complex data to identify trends, variances, and problem areas
• Developed and successfully implemented and Database backup policy and plan
• Created and developed highly complex stored procedures, functions and triggers to build consistent reports
• Developed ETL and ELT scripts to enable weekly/monthly processing of data sets into data warehouse.
• Imported data from other LAN based system and flat files to RDBMS
• Formulated procedures for integration of R programming plans with data sources and delivery systems.
• Participate in Designing high-end software/web applications consistent with unique client requirements specific to the dental healthcare domain such as HIPAA and Meaningful use EHR, introduced advanced methods to resolve complex problems and enhance user experience
• Made recommendations towards the development of new code or reuse of existing code, suggest and introduce tools, framework, and processes to the development team, in efforts to help improve efficiency in the development process
• Contributed to a motivated work environment by working effectively to achieve common goals, provide technical advice and assist in solving programming problems
• Actively participating in eCRF harmonization initiative, based on CDISC standards, across multiple diagnostic business areas within Roche.
• Developed test data and perform the unit testing ensuring that the programs perform according to program specifications; involved in the full systems life cycle and responsible for designing, coding, testing, implementing and supporting applications software that is delivered on time and within budget
• Coordinates activities of co-workers, clients, operations, technical support, and vendors. Interfaces with business partners and key stakeholders to determine requirements, and resolve problems, assists project team members, including vendors, in their understanding of project requirements and business impacts
• Exceeded duties with 24/7 support ensuring maximum uptime.

Programmer Analyst

Confidential, Folsom, CA

Responsibilities:

• Initiated programming and formulas to provide solutions to user requests; assisted in design, development, testing, and documentation of new software applications
• Developed database, tables and fields, Indexes and foreign key relations in physical Relational Databases.
• Coordinated with programmers and analysts to create Business Objects written in Visual Basic which allowed users to select specific fields and apply filters when creating SQL statements
• Participated in web design meetings and analyzed user needs to determine technical requirements, developed and maintained websites or web applications involving multiple programming languages, participated in defect review meetings with Management and Developers to prioritize defects
• Modified, repaired, or expanded programs to correct errors, increase efficiency, upgrade interfaces, or improve performance, performed testing and analysis on web and systems to identify problems
• Gathered and analyzed business, technical, functional requirement documents, provided training to test team members on test tools, test process, test strategies; created Test Automation Process, Standards and Setting Up Test environment for Automation Testing using Quick TestPro (QTP)
• Assisted in pricing of securities including bonds and mortgages in programming domain such as C++, MTLAB and R programmin
• Wrote a test plan for GUI, Functionality, Integration and Performance Testing, weekly review meeting, reported test progress status to management, wrote test cases to validate all the functionalities with positive and negative test data
• Advocated quality of product to users, defect reporting and tracking using Quality Center, supported User Acceptance Testing and end-user training, scheduled and conducted meetings to retrieve project requirements, and addressed concerns from the business users.