PROFILE

• Over 7+ years of experience in all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, data architecture, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation using Microsoft Technologies.
• 5 - 7 years of experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Reporting solutions using Microsoft SQL Server Reporting Services (SSRS), DTS, Performance tuning, Designing logical/physical databases and Troubleshooting.
• Expert T-SQL development skills in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, Correlated sub-queries, Cursors and Triggers using SQL Server 2000/2005/2008 R2/2012
• Experience in report writing using SQL Server Reporting Services and creating various types of reports like Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS 2008.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Excellent in High Level Design of DTS and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in using Fuzzy Lookup and Fuzzy grouping transformations for data cleansing.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Experience in defining logging for packages to record the error records, updated records, and inserted records.
• Experience in creating jobs, Alerts and schedule SSIS Packages using SQL Agent.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

PROFESSIONAL EXPERIENCE

CCL Developer/Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Worked on building various reports in Explorer menu to streamline the workflow of Doctors, Nursing staff and for reporting purposes.
• Created Interactive reports using Mpages at Organizer level in Power Chart.
• Built smart templates to simplify patient documentation.
• Worked on building various Conversation rules in Patient Management and make the registration staff workflow much easier.
• Worked with Meaningful use reporting and Regulatory measures - ACI and ECQM.
• Performed historical loads to get Stage 3 measures accurate.
• Created custom scripts for various Data fix operations.
• Build various reports in Revenue cycle to ensure that the patients are in correct workflow and have correct action codes listed.
• Involved in various performance tuning of slow running CCL reports.
• Worked on Firstnet Emergency department reporting on ED stats for County reporting and CMS reporting
• Worked on reporting to McKesson and Press Ganey using FTP protocols.
• Involved in building the Charge Master for Charge auditing.
• Worked on various projected to get the data from 3M to Cerner with respected to DRG and Diagnosis of the patients.
• Worked extensively on the Surgery optimization and Surgery reporting to Theradoc.
• Worked with infection control for infection prevention and proactively checking on the measures to be taken based on past data.
• Involved in projects by Diet and Nutrition department for NPO auditing.
• Worked on Qlikview reporting and dashboards for Data warehousing needs.
• Extensive knowledge in Patient Portal and E-Prescribing reporting.
• Worked closely with Pharmacists for their quality reporting, control substances and high risk patients.
• Worked with executive staff for benchmarking of Census for 2 years and patient documentation statistics
• Worked with integration team and Big data team to warehouse Cerner data to get near real-time dashboards.
• Worked closely with Optum, Theradoc and PricewaterCoopers for Patient data management and reporting to NHSN and Benchmarking

Environment: Cerner Applications- CCL Programming, Qlikview, Report Writing, Person Management Applications, HIM applications, Power Chart, First Net etc. SQL Server 2014, Oracle 9i, Management Studio, Microsoft SQL Server Integration Services(SSIS), C#, ado.net, Windows 2012 Server/2003 server, SQL Server Reporting Services SSRS), Microsoft Visual studio 2013/2015.

Sr. Systems Analyst Programmer

Confidential, Long Beach, CA

Responsibilities:

• Worked extensively on building various kinds of reports in CCL for Hospital Census and Operations/Performance and scheduled ops jobs to report the performance to reportable agencies.
• Created Powerforms to record vitals and to drop charges on a patient and associating them to task interventions for easy charting.
• Created CCL Scripts for Powerchart to bring in Patient useful data on to the banner bar and to create pre completed notes useful for Providers.
• Create various CCL Scripts to infuse into smart templates for Clinical Documentations and patient educations.
• Created user level preferences so that users can have various access levels relevant to their role.
• Worked on projects for GI lab to capture patient data into clinical images securely and quickly.
• Trained various physician and nursing staff about the EMR and quick access to various information needs for patient care.
• Worked and created various Person Management conversation rules and build for easy documentation.
• Extensive knowledge in HIM applications and built for easy reporting and rendering services.
• Create new reports in both SSRS and Cerner for Hospital and clinics use to analysis the patient count and treatment effectiveness.
• Created CCL Scripts to do various Data-fix operations on the backend of Cerner remove any errors caused by incorrect documentation.
• Worked at Cerner Help desk to resolve various Cerner issues for RNs, LVNs and Physicians effecting patient care.
• Involved in various performance tuning of slow running CCL reports
• Created the subscription and scheduled various ops jobs for diet and case management.
• Worked on building ASAR forms in .Net for Cerner Access ticketing system implemented in the Hospital.
• Involved in the go live of Out-Patient Clinic and implementation of MPages for Ambulatory view of Power chart for various positions of clinic staff and Charges associated with the orders and visits.
• Mentoring the other Analysts with applications like PowerChart, FirstNet, DCP Tools, Revenue Cycle, Order Managements, Bedrock.
• Troubleshoot various interface issues in the hospital from Clinical to IBus engine, Finance to Case Management, Patient Coding, Lab and Pharmacy.
• Worked 24x7 on call person for all the IT and Cerner related EMR issues in the facility.
• Worked with various vendors like Omnicell, Pacs and Fuzi for various enhancements to Medication dispense and GI lab imaging.
• Lead and implemented projects for to get Blood glucose optimization for nursing staff to avoid manual documentation which prevents various documentation errors.
• Designed secondary database integrating Cerner, Onbase and EBS systems to get a sync in SQL Server Database for various end users in HIM and Business Office.

Environment: Cerner Applications- CCL Programming, Report Writing, Person Management Applications, HIM applications, Power Chart, First Net etc. SQL Server 2014, Oracle 9i, Management Studio, Microsoft SQL Server Integration Services(SSIS), C#, ado.net, Windows 2012 Server/2003 server, SQL Server Reporting Services SSRS), Microsoft Visual studio 2013/2015.

SQL/SSRS/Cerner Developer

Confidential, Long Beach, CA

Responsibilities:

• Closely worked with the Doctors, business users, Database analyst get the requirements for report development in both SQL and Cerner.
• Create new reports in both SSRS and Cerner for Hospital and clinics use to analysis the patient count and treatment effectiveness.
• Create Scripts and stored procedures to do various Data-fix operations on the data from the backend of CPS used in the Clinics.
• Worked in war rooms for production support and on demand reporting on SQL Server data base.
• Created various forms for the patient vitals on Visual Form Editor for various clinical purposes.
• Created various reports using CCL and record structures to determine the performance of the Hospital
• Created Tablix, Drill-down, Drill-through, Matrix, Tabular, Multi Parameterized, Linked, Chart and data driven reports using SSRS 2008/2012.
• Involved in various performance improvement of slow running reports. Assigning security and permissions to reports
• Created the subscription and scheduled the published reports from Report Manager.
• Worked on writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Worked on creating on demand report for the business users for various analysis.
• Worked on creating SSIS packages for various data transformations and used data cleansing operations to get then in the desired format.
• Used various components of the control flow task and data flow task to perform various transformation both custom and built-in and used logging mechanisms
• Worked extensively on Centricity Practice Solutions and Cerner for various clinical applications.
• Worked on record structure style programming on Cerner databases.

Environment: SQL Server 2012/2005, Oracle 9i, Management Studio, Microsoft SQL Server Integration Services(SSIS), C#, ado.net, Windows 2012 Server/2003 server, SQL Server Reporting Services SSRS), Microsoft Visual studio 2012/2005, SQL Server Profiler, Cerner.

SQL//SSRS/SSIS Developer

Confidential, Scranton, PA

Responsibilities:

• Closely worked with business users and business analyst to gather user requirements and generate high level BRD’s and Report Mockups for the Report Development.
• Actively participated in design, development discussions with DBA, team lead and project manager and performed impact analysis.
• Performed detail Data Analysis and Reconciliation of the projects and provided better approach to the system.
• Created SSIS packages to extract data from different data sources (SQL Server, Oracle, Access, Flat files, Excel files) and loaded them into OLAP system by performing different kind of transformations to fulfill business needs.
• Created Tablix, Drill-down, Drill-through, Matrix, Tabular, Multi Parameterized, Linked, Chart and data driven reports using SSRS 2012/2005.
• Highly involved in performing Unit Test, Regression Test, Functional Test, Integration Test, and Stored Procedure Performance Test on Test server and preparing combined Developer Testing document.
• Created Report level security and assign user permissions on Report Manager.
• Created the subscription and scheduled the published reports from Report Manager.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2012.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Created SSIS Packages by using advance transformations (i.e. Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate)
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.

Environment: SQL Server 2012/2005, Oracle 9i, Management Studio, Microsoft SQL Server Integration Services(SSIS), C#, ado.net, Windows 2012 Server/2003 server, SQL Server Reporting Services SSRS), Microsoft Visual studio 2012/2005, SQL Server Profiler.

SQL Server BI Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Created complex Stored Procedures, triggers, cursors, tables, views and SQL joins and statements for applications by using T-SQL.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Environment: MS SQL Server 2008, SSIS, SSRS, OLAP, OLTP, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, Performance Point Server, ASP.Net, C#, IIS 4.0, Visio 2000, SQL Server Query Analyzer, SQL Profiler, MS Access.

MSSQL Server Developer

Confidential, Denver, CO

Responsibilities:

• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Developed Stored Procedures, Functions, Tables, Views, Triggers, Cursors, User Defined Functions, other T-SQL code and SQL joins for applications to handle large amount of data manipulation.
• Errors handling using TRY and CATCH blocks and performance-tuning the SQL Code.
• Creating ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Responsible for transferring the data using SSIS packages from excel/flat file sources to database.
• Published migrated data using SSIS (SQL Server Integration Services) Tool through data flow tasks, look up transformations and script tasks.
• Creating Logging and Error Handling in SSIS Packages
• Responsible for deploying/scheduling SSIS packages as per schedule.
• Monitoring, Identifying and troubleshooting SQL Server performance issues using SQL Server Performance monitor, profiler and Performance dashboards
• Responsible for creating a trace to identify and analyze the Poorly Performing Queries Identified by Profiler in SQL Server 2008 R2.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developing Cascading Reports for Analytics Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2008 R2
• Creating and deploying various Reports like Drill Down, Drill Through, Chart, Linked and Parameterized reports using SSRS
• Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Performing Unit and Regression tests for Developed Reports and Deployed into the Server
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users.

Environment: Microsoft SQL Server 2008 R2, Business Intelligence Development Studio (BIDS 2008 R2), Management Studio, Visual Studio 2010/2008, .NET Framework, Windows Server 2003.

SQL Server/BI Developer

Confidential, San Antonio, TX

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Involved in business requirement gathering, technical design documents and data mapping.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation..
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Used various Transformations in SSIS Data flow, Control Flow using for loop Containers, and Lookups etc.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2005
• Created copies of operational Databases using the Import/Export Wizard.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005
• Involved in creating report models and applying row level security filters for report model.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

SQL Server Developer

Confidential

Responsibilities:

• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Implemented batch processing using Jobs and DTS.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Rules, and Indexes.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard).
• Scheduled Jobs using SQL Server Agent.
• Used SQL Server System Catalog to find Stored Procedures, UDF, Triggers, Tables, indexes and constraints on existing databases.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Used various levels of triggers and procedures to validate the data at each level.
• Extensively involved in writing stored procedures, triggers, functions and packages based on the client requirements.
• Created database tables with complex constraints applicable to the business rules.
• Analyzed requirement of client and worked on developing and designing reports.

Environment: SQL Server 2000, Crystal Reports, MS Access, Excel, MS Word and Windows NT

TECHNICAL SKILLS

Database: SQL Server 2008R2/2005/2000, Oracle 9i/10g, Microsoft Access.

Database Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, DTS, SSIS, SSRS.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), BCP, Import Export Data, Bulk Insert.

Data Modeling Tools: MS Visio

Programming Language: T - SQL, C, C++, PL/SQL, Visual Basic 6.0, C#.

Reporting Tools: SSRS, Crystal Reports

Operating Systems: Windows Server 2003/ 2008, Windows XP, Windows 7, MS-DOS, UNIX, Linux.