PROFESSIONAL SUMMARY:

• Experience in developing the applications using T-SQL Programming (DDL, DML and DCL).
• Expert in creating SQL objects like Tables, Complex Stored Procedures, Views, Indexes, and User Defined Functions to facilitate efficient data manipulation and consistent data storage.
• Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS).
• Proficient in implementing all transformations available on the SQL Server Integration Services (SSIS) toolbox.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files, OLE DB source, XML source, ADO NET source, Raw File Source to Flat Files, Excel Files
• OLE DB Destination & ADO NET Destination.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export, SSIS packages, and DTS package.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Expert at creating reports using SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) 2016,2008/2005.
• Designed and deployed Tabular, Matrix, Chart, Linked, Drill-down, Linked reports, Sub reports, filters, charts and Drill-through Reports with drop down list of parameterized options in SSRS 2016,2012,2008/2005.
• Experienced in developing Custom Report and different types of Chat Reports, Tablix Reports, Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Created Parameterized reports, Drill through reports, Drill down reports & Cascading reports.
• Deploy and manage the reports to a report server and securing and managing the reports with Reporting server.
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Excellent exposure on Software Development Life Cycle (SDLC) and Onshore/Offshore model.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. perience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MSExcel spreadsheets and Power Pivot.
• Experience in creating and designing SSIS Packages for Integration and Migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS in MSBI and SSDT.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in Error handling using Stored Procedures and Views.
• Extensive success in translating business requirements and user expectations into detailed specifications employingUnified Modeling Language (UML) in an SOA environment.
•  Proficiency with programming languages including but not limited to classic ASP, MVC5 (or higher) Microsoft.net framework (C#/ ASP.Net), SQL.
• Experience in the Data Analysis, Data Mining, Data Mapping, Data Quality, and Data Profiling.
• Established priorities and organize assignments, and to work effectively within timelines and under general supervision.
• Understand rules and regulations of HIPAA as imposed during Electronic Data Interchange (EDI) in 4010 and 5010formats like 837 - Claims and Encounters.
• Creation of a Mapping Document for ICD9 Codes to ICD 10 Clinical Modifications and Procedural Codes.
• Deep expertise and hands on experience with Web Applications and programming languages such as HTML, CSS, JavaScript, JQuery and API's.
• Evaluated and provided design documentation with input from both internal and external business usersfor claims processing software system
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL andReporting team.
• Identified & documented data sources and transformation rules required to populate and maintain data warehousecontent.
• Elicited, documented, modeled, validated and prioritized functional and non-functional requirements usinginterviews, data analysis, and different modeling tools.
• Worked for for Claim payment production issues that require Business and application knowledge.
• Skilled in unit testing, system integration testing and user acceptance testing.

TECHNICAL SKILLS:

Languages:  C#, VB.NET, ASP.NET, Web Services, HTML, XML,JAVA SCRIPT,JQUERY,AJAX

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008,2012, Teradata, Sybase, UDB (EEE), Mainframes(DB2 and Sequential Files), SQL*Plus, SQL Loader.

BI Tools:  SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS)

Operating Systems:  Windows Vista, Windows XP/7, MAC OS

Microsoft Tools:  MS Office Suite (Word, Excel, Power Point, Outlook), MS Share Point,MS Visio, MS AccesS

Data Modeling Tools:  TOAD 9, Maestro, Erwin 4.0 (Dimensional Data Modeling, Star schema, Snowflake schema), Physical and Logical Data Modeling.

PROFESSIONAL EXPERIENCE:

MSBI DEVELOPER/DATA ANALYST

RESPONSIBILITIES:-

• Worked as part of a team for gathering and analyzing Business Requirements.
• Worked on Business Case Document for Policy Change s.
• Worked for 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 claimfor 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 betweenthe 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 tothe 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 forRxvendor, 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.

MSBI DEVELOPER

RESPONSIBILITIES:-

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.
• Installed and configured SQL Server 2008 successfully.
• Performance testing on stored procedures, Indexes.
• Maintained databases, performed software installations and monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Implemented automated backup and database maintenance / cleanup jobs.Generated Views for specific columns on a table to maintain privacy of a customer data.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers andviews, partitioned views.
• Analyzed the existing data and performed the migration steps from SQL Server 2005 to SQL Server 2008.
• Used different tasks, transformations, containers and source/destination components to create SSIS packages.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.
• Extract data from access, excel, flat file, and different data base and load in SQL data base Using SSIS packages.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Verified different packages using Views using SQL Integration services 2008.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Involved in generating summary reports like Tabular, Matrix using SSRS.

ENVIRONMENT:Windows 2007 Server,IIS 6.0,Windows 2007, MS SQL Server 2005/2008, Office 2003, Visual Studio, Database Engine Tuning Advisor, SQL Server Management Studio, SQL Server Business Intelligence Development Studio,SSIS,SSRS.

SSIS/SSRS DEVELOPER

RESPONSIBILITIES:-

• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL)
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis.
• Assisted business users and end users to schedule and write subscriptions on report manager.
• Used Multi-dimensional expressions (MDX) to present the data asked by the user, to simultaneously query on different dimensions.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Created and deployed several packages in SSIS.
• Deployed and configured the reports in the Report Server.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, XML files, flat files to SQL server 2005.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005 (SSAS).
• Created stored procedures and user-defined functions for different Reports.
• Created complex correlated sub queries to generate reports.
• Created Databases,Tables,Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Modify SQL queries to upgrade SQL Server performance using SQL Server 2000/2005.
• Supported OLAP team to provide data from SQL Servers and generating reports.
• Converted crystal, actuate and MS Access reports to SQL reports, generated reports using crystal reports.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.

ENVIRONMENT:SQL Server 2005/2000,SSRS 2005,SSIS 2005,SSAS,C#,ASP.NET,Oracle 9i/10g, Visual Studio 2005,XML,XSLT,MS Office and Visual Source Safe.

SQL SERVER DEVELOPER

RESPONSIBILITIES:-

• Involved in Creation, Manipulation and Supporting the SQL Server Database.
• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Extensively involved in designing the DTS packages to make the automated synchronization of data from one system to another system.
• Involved in migration of Data from Excel, Flat file, Oracle, XML files to SQL Server by using BCP and DTS utility.
• Create and test DTS packages for importing and exporting data from data warehouse.
• Schedules jobs for DTS packages.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2005.
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring
• Create Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc from event viewer, SQL Error log files.
• Analyzed and implemented backup and database maintenance plans.
• Configured Mail Profile for sending automatic mails to the respective people when a job failed or succeeded.
• Administering MS SQL Server by Creating Logins and assigning appropriate roles.
• Involved in SDLC from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement, creating mappings, and loading the data into different targets.

ENVIRONMENT:SQL Server 2005,SQL Profiler,DTS,T-SQL,BCP,System monitor/Performance Monitor, Query Analyzer.

9