SUMMARY

• Over 6+ years of IT experience in Design, Development and Maintenance of Database applications using PowerBI & SQL Server 2012/2008R 2/2008/2005.
• Expertise in scripting DDL, DML, T - SQL (Complex VIEWS, Stored Procedures (SP), Functions, Triggers and Indexes).
• Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP, OLAP and Normalizations.
• Good Experience in Tuning SQL Queries by implementing Indexes and using Stored Procedures.
• Good Experience in Extraction, Transformation and Loading (ETL) in SQL Server database using SQL Server Integration Services (SSIS).
• Experience in Implementing Checkpoint, Transactions, Logging.
• Experience in building Package Deployment and Package Configurations.
• Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages using SQL Agent.
• Good experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Proficient in developing all types (Tabular, Matrix, List, Drill-Down, Drill-Through, Sub-Reports, and Chart Reports) of Complex Reports using SQL Server Reporting Services (SSRS).
• Experience in Implementing Dynamic Grouping, Sorting & Page Breaking using SSRS Parameters.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Expert in troubleshooting/resolving SQL Reporting services and SQL related issues.
• Good Knowledge in SQL Server Analysis Services (SSAS) 2012/2008R2/2008/2005).
• Used SSAS Cubes as data source for Reports Development.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Experienced in developing ETL packages using SSIS SQL Server Integrated Services.

TECHNICAL SKILLS

BI Data Warehouse Tools: SSRS, SSIS, SSAS, Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, MSBI,Power BI.

Databases: MS SQL Server 2012/2008/2005 , MS Access, Oracle.

Languages: C,C++,HTML,T-SQL,MYSQL,PLSQL.

App. /Web Servers: IIS 5.0/6.0

Reporting Tools: ETL SSRS, SSIS, SSAS, Report Builder.

Platforms/OS: Windows 98/2000/2003/ XP/NT/Vista, Windows 7

Others: SQL Server Data Tools, BIDS, SQL Server Management, Studio, Office 2005/2008/2010.

PROFESSIONAL EXPERIENCE

Confidential

SQL-ETL BI Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server 2012.
• Planned, designed, and implemented processes to Extract transform and load data from external sources into local databases.
• Installed and configured SQL Server 2008R2/2012 in Test environment with latest service packs and migrated few databases.
• To keep track of data manipulations using Audit functionalities.
• Developed physical data models and create DDL scripts to create database schema and database objects
• Implemented Error Logging using Event Handlers and implemented logging in SSIS Packages.
• Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
• Created Customized and interactive dashboards using multiple data sources.
• Created Dimensions with the cube wizard and individually and Generated Named calculations and named queries.
• Created Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Developing SSIS packages to bring data from Claims databases to data warehouse tables.
• Worked with Claims, Members, Providers and Authorizations for loading the data into SQL server using SSIS packages.
• Analyzed current Claim Authorization Process across all the FACETS Markets. Identified possible constrains that pends claims related to Claim Authorization Mismatch.
• Configured best suitable Facets CLUM Settings to auto-adjudicate maximum number of pended claims.
• Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Vast knowledge and experience in Health Care industry, experienced in testing different healthcare ERP solutions such as FACETS, Med Plus, EPIC and other claim processing solutions.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2010, SSRS, SQL Server Management Studio (SSMS), MS Excel, Windows XP/7.,MSBI,&PowerBI.

Confidential

Business Analyst

Responsibilities:

• Expertise and experience in quantitative and qualitative data collection and appropriate analytic capabilities
• Analyze data using statistical and relational database software
• Research contents, limitations, and potential uses of all available data sets relevant to assigned task areas.
• Cleans and prepared data for analysis to develop dashboards, conduct surveys, focus groups, interviews, environmental scans, case studies and to process and analyze data obtained from these data collection methods
• Develop documentation for all analyses to include storage location of all files.
• Develop measures to assess contract performance in assigned task areas and make changes as required per project specification.
• Collaborate with other analytic team members to troubleshoot problems in a timely manner.
• Collaborate with analytic group membersto check program codes for adherence to specificationsfor correct results.
• Provide technical support to customers including answering questions, trouble-shooting problems and assisting in modification of program code
• Define and analyze complex data, develop visualizations, and construct compelling presentations for various audiences.
• Design, produce, analyze, and debug routine data reports using PowerBI.
• Report results of statistical analyses (i.e. graphs, charts, tables, written reports)
• Perform dada reconciliation for data verification during data migration by comparing target data with source data to ensure the migration architecture is transferring data.

Environment: MS SQL Server 2012/2008/2005 Enterprise Edition, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T- SQL, VSS, Windows Sever 2000/2003/2008 , SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio.

Confidential

PowerBI & ETL Developer

Responsibilities:

• Extract, Transform, and Load (ETL) data in SQL Server database using SQL Server Integration Services (SSIS). Data extracted from different Sources (OLE DB Source, File, Excel etc.) that are build in the ETL tool. Data transformed using different SSIS transformations (Aggregate, Lookup, Data Conversion, Derived Column etc.) so the source data can be transformed in any required format. Data loaded to different types of Destinations (OLE DB, ODBC, ADO Net, Flat File, Raw File etc.) after being transformed as required.
• Complete system design documentation and publishing using MS Word, MS Excel, MS Power Point, and Power BI.
• Gathering data from diverse groups and converting them into detailed logical flow charts and specifications for a business solution.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files. Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Worked in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Worked on dimensional modeling, creating cached reports, drill-down reports, linked reports, report snapshots, parameterized reports and report optimization Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Expertise in providing comprehensive solutions in multi-industry, multi-cultural environments. Exceptional project management skills with vast experience in working within tight time frames
• Review and approve quotations from contract manufacturers by following cost review procedures that incorporate the analysis and calculation of cost of goods sold (COGS).
• Coordinated with front-end for implementing logic in stored procedures and functions.
• 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 2008 to SQL Server 2012. Migrated SQL server 2008 R2 packages to SQL Server 2012 SSIS packages using SQL Server 2012 Upgrade Advisor.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, C#, MS Visual Source Safe and Windows Server 2003.Power BI, MSBI