SUMMARY:

• Over 8+ years of professional experience in development, implementation and administration of database systems using MS - SQL Server … for both OLTP & Data Warehousing applications.
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server DTS, SSIS, SSAS and SSRS
• Skilled in design of logical and physical data modeling using Erwin data modeling tool
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Experience in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Good Knowledge of Data Warehouse/Data mart concept and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS). Bulk Insert, BCP.
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• In-depth experience of Transact-SQL (DDL and DML) operations
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS)
• Possess detailed knowledge of aggregation using OLAP analysis services cube.
• Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
• Worked Extensively on ETL process using SSIS package.
• Expertise in creating and managing Event Handlers, Package Configurations, Error Handling, Logging, System and User-defined Variables for SSIS Packages.
• Experience in scheduling the jobs for SSIS packages, sending alerts using SQL Mail task.
• Database Administrative skills including, backups, recovery, database maintenance.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server
• Developed Dashboards, Gauges, Tabular, Matrix, Charts, Crystal reports Parameterized and Sub-reports in SSRS
• Extracted Data from various locations such as Excel and flat files to SQL server SSIS
• Experience in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• In-depth experience of SQL (DDL and DML) operations, Extensive experience in Tuning SQL queries and improving the query performance
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams

TECHNICAL SKILLS:

Programming Language: SQL, PL/SQL, T-SQL

Operating Systems: Windows 10/vista/XP/7 ETL& Reporting Tools SSIS, SSRS, Microsoft Office

Web Designing: HTML, XML, CSS Databases Oracle 11g/12c, SQL Server Management studio Development Tools SQL Developer, SQL visual Studio, BI visual studio

WORK EXPERIENCE:

MS SQL Developer/SSIS Developer

Confidential, East Greenwich, RI

Responsibilities:

• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Successfully extracted data from flat files/excel files, applied complex transformation and loading data to SQL Server datamart and data warehouse on daily, weekly, biweekly, monthly basis.
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Loaded Excel files consist of OLTP data and processed it with the stored procedures to comply certain rules depending on the company and incentive offers.
• Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse
• Optimization of queries by looking at Execution Plan for better tuning of the database
• Implemented Try and Catch block instead of the @@Error in the stored procedure for a better error handling.
• Used SQL Server Agent for scheduling jobs and alerts
• Provided technical guidance and support to end-users by developing documentations required.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Assisted with various ad hoc query requests
• Extensively used SSIS transformations such as Lookup, Fuzzy Lookups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Provided back-end support for functional testing, performance testing and provided testing evidence
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
• Used Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning.

Environment: SQL Server 2008R2 enterprise edition, BIDS (SSRS, SSIS, SSAS), Oracle 10g, Windows XP, Erwin 7.1

Confidential, LEXINTON, KY

MSBI DEVELOPER/DATA ANALYST

RESPONSIBILITIES:-

• Worked as part of a team for gathering and analyzing Business Requirements
• Worked on Business Case Document for Policy Changes
• Worked for Claim payment production issues that require Business and application knowledge
• Worked on key Guidewire Functionalities also such as Activities
• Worked on Guidewire, extensively worked on Guidewire Policy center & Guidewire Claim Center
• Involved in preparing detailed Business Analysis documents, Worked extensively with SMEs and performed Gap
• Analysis to arrive at the gaps between current and future systems and the modules to be impacted
• GuideWire Claim Center is the project which was undertaken to upgrade the current Claim System to track its claim for both their owned Policy holders and third party applications.
• Used SharePoint on a daily bases to manage requirement workbooks and a vast range of other documents
• Helped streamline the 276/277 transaction in order to enable easier and faster exchange of information between the payer and the provider.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Use analysis and experience to ensure data is properly mapped from the OLTP system to the staging area and to the Claims Data Warehouse.
• Creation of a Mapping Document for ICD9 Codes to ICD 10 Clinical Modifications and Procedural Codes
• Effectively worked with architects on migration projects and created mapping documents for Rx vendor, Claim Routing, 3rd party vendor extracts in Crystal Reports.
• Performed performance tuning of stored procedures using SQL Server Profiler.
• Involved in the development of custom stored procedures, functions.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server 2012.
• Designed SSIS packages to migrate the data from PDX files to the Staging Area in SQL server 2012.
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2012.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Installed and administered Microsoft SQL Server 2012/05, SQL Server Integration Services 2012/05, SQL Server Reporting Services2012/05 and Team Foundation Server 2008/2005.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Saved the SSIS Packages and Reports in SourceSafe
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Generated Reports using Data Source Views in Report Builder 2.0
• Developed Reports Using SSRS on statistical data during migration of data
• Created Drill Down, Drill through, linked and sub reports using SSRS 2012.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Extensively designed and developed reusable transformations & aggregations and created target mappings that contain business rules.
• Used MDX queries for pre calculated measures.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server
• Used UML for Design and Documentation

ENVIRONMENT: SQL Server 2012,2008/05, T-SQL, Windows XP/2007, Visual Studio 2010,2008/05, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, Share-Point.

Microsoft SQL Server/Business Intelligence Developer

Confidential, Saddle River, NJ

Responsibilities:

• Participated in gathering User Requirements and System Specifications
• Created SSIS packages to extract data to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Extract Transform Load (ETL) development using SQL Server 2008R2, SQL 2008 Integration Services (SSIS)
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling And Logging.
• Enhancing and deploying the SSIS Packages from development server to production server
• Created SQL Jobs to schedule SSIS Packages
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS
• Performed Documentation for all kinds of reports and DTS and SSIS packages
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Migrating SQL Server 2008 databases into SQL Server 2008r2
• Installed SQL Server 2008 R2 on standalone and cluster environments
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Creating Reports as per user requirements using MS Reporting Services 2008/2008R2 Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS
• Created views and Stored Procedures for generating report, Responsible for creating the reports based on the requirements using SSRS 2008R2/2008. Extensively worked in sorting the data, defining subtotals for the reports
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
• Developed MDX queries and Data Mining Expression (DMX) queries for SSAS 2008 and SSRS 2008
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed flowcharts for complex stored procedures.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance
• Effectively used views to prevent unauthorized access

Environment: SQL Server 2008/2008 R2, VBScript, XML, SQL Profiler, SQL Crystal Reports, MS Visual Studio.NET, Performance Point Server, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Visio, Access, XML, Web Services, VB.NET.

SSIS/SSRS Developer/Analyst

Confidential, Eden Prairie, MN

Responsibilities:

• Worked closely with Developers, Quality Assurance Analysts, Architects, Business Partners and other Technology teams to ensure requirements and design are completely understood.
• Participated in agile meetings.
• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Developed various SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly data runs completed by the users using SSRS.
• Used Oracle and SQL server databases in loading/mapping the data into the product layout, This includes understanding the claims data, ICD9, ICD10 diagnosis codes, procedure codes, CPT codes, pharmacy claims, laboratory claims, in-patient, out-patient claims.
• Performed highly complex data analysis for medical analytical software using HEDIS specifications.
• Designed and developed commercial and business applications using Quality Engine, Quality reporter, Data Audit, Measures developer, HEDIS certification and ETL methods.
• Written complex queries and coding packages for complex data.
• Performed analysis of product/process launches in the environment.
• Updating insert and Audit functions.
• Understanding/documenting the requirements of the clients request and built SQL reports
• Coded and executed translations and custom chases in addition to the standard process and performed various data warehouse administrative functions as required.
• Scheduled automation runs and written test cases on the product functionality.
• Designed and executed the test plans to ensure system requirements are met.
• Retrieving and reforming data from various client health care databases
• Performed quality assurance on encrypted data marts and used secure file transfers.
• Conducted data audits to clean client's data.
• Used Microsoft access, txt, excels formats for retrieving/loading the data.

Environment: Oracle 11g, MS SQL Server 2012/2008, SSIS, SSRS, Windows7, XP, MS office, MS Excel.

SSIS/SSRS Developer

Confidential, Kansas

Responsibilities:

• Monitored, analyzed and evaluated complex organizational data with statistical tools to identify trends, variances, and problem areas.
• Ensured the integrity and accuracy of the data. Identified any discrepancies in the data and worked with the appropriate members of IT to resolve the issue and ensure that the data integrity is maintained if data is not being captured correctly.
• Developed and maintained ETL jobs for data warehouses/marts
• Designed ETL via source-to-target mapping and designed documents that consider security, performance tuning and best practices
• Tested ETL and other technical components and support QA
• Documented technical specifications, data models, process flows, etc.
• Collaborated with delivery and technical team members on design and development
• Collaborated with business partners to understand business processes, underlying data and reporting needs
• Conducted data analysis in support of ETL development and other activities.
• Assisted with data architecture and data modeling.

Environment: Oracle 11g, SSIS, SSRS, MS SQL Server 2008/2005, Windows7, MS office

SSIS Developer

Confidential

Responsibilities:

• Generated database SQL scripts and deployed databases including installation and configuration.
• Created and developed stored procedures and triggers to handle complex business rules, history data and audit analysis.
• Filtered bad and inconsistent data using complex T-SQL statements and implemented various constraints and triggers to maintain data consistency.
• Used SQL script to find heavily fragmented indexes and have re-organized the indexes accordingly to get desired performance from the tables.
• Created insert, update and delete triggers on some tables to capture any DML activities happening on some crucial and confidential data.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Migrated data from heterogeneous data sources and legacy systems to a centralized SQL Server using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Implemented Error handlers and Event handlers in SSIS packages
• Created packages to validate, extract, transform and load data to centralize SQL Server using OLEDB providers from the existing diversified data sources.
• Maintained databases, performed software installation and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check using DBCC commands.
• Experience in handling jobs, work flows and data flows using Data Integrator Designer
• Excellent data analysis skills and ability to translate specifications into a working report.
• Worked with data services performance tuning techniques like source based, target based and degree of parallelism.
• Transferred data from the source to target by creating data stores.
• Experienced in debugging and performance tuning of sources, targets and mappings
• Research denials to identify and implement changes needed to our systems in order to meet payor requirements around claim formatting, billing and submission guideline.
• Identify updates and/or changes to payor requirements prior to implementation and work with applicable Revenue Operations teams to ensure those changes are accurately reflected in all systems.
• Developed/run SQL queries to analyze system data in order to clearly identify scope of changes needed, and to evaluate needed business decisions and approvals before changes can be made in our systems.
• Make system architecture decisions using payor documentation, system knowledge and business rules, to efficiently and compliantly set up our systems in line with payor requirements.
• Conduct research and ad-hoc analysis to support revenue cycle goals. Designer and Developer

Environment: Oracle 11g, MS SQL Server 2012/2008, SSIS, SSRS, Windows7, XP, MS office, MS Excel.