SUMMARY

• Over 8+ years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2005/2008/2012/2014 with various business domains like Financial, Banking, and Insurance Sector
• Experience in MS SQL Server 2014/ 2012/2008/2005 with Business Intelligence in SQL Server Reporting Service and SQL Server Integration Service
• Experience in designing Logical and Physical Modeling using ERWIN Tooland ER Studio.
• Experience in High Level Design of ETL - DTS Packages&SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Involved in migration of reports from SQL 2000 to SQL 2012/2008 and migration with DTS to SSIS.
• Proficient in OLTP, OLAP and Data warehousing Design concepts
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL
• Experience in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2012/2008
• Experience in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS
• Responsiblefor taking information from all new clientsand starting new client files.
• Assisted in doing monthly HIPPA audits for clientsand presenting theresults to theclientsand company management
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2008/2012 Analysis Services Business Intelligence (SSAS, SSRS).
• Experience in creating MDX query in SSAS cube for various calculated members, KPI and various actions such as drill through, reporting etc.
• Proficient in Process change implementation,DAXservices and integration with the external applications like .NET applications,DAXSSRS reports,DAXbatch jobs, building newDAXrich clients to further extend the functionality ofDAX. Work with your internal and or offshore team to deliver the work.
• Experience in Accessible Web Design and development, W3C Web Content Accessibility guidelines.
• Expertise in using Microsoft technologies such as, .NET Framework 4.5/4.0/3.5/3.0/2.0 , Web applications using ASP.NET, Win Forms using Microsoft Visual C#.NET, VB.NET, and components, database access using ADO.NET, and distributed applications using WCF, XML Web Services and Messaging system to develop applications.
• Experience in web-based page and site designs using HTML5, XHTML, DHTML, CSS, Themes, Master Pages, Bootstrap, Site Map, JavaScript, Angular JS, JSON, JQuery, MVVM design pattern and AJAX.
• Experience in using HTML, and Java Script, Angular JS, and Server side validations with ASP.Net to validate Client forms
• Strong understanding in Object Oriented programming and the ability to develop and support applications in C#/.NET.
• Experience in advanced reporting skills using SQL Server reporting services (SSRS).
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes
• Experience in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, Also created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
• 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.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2012/2008)

Database: MS SQL Server 2012/2008/2005 , MS Access, Oracle 11g/10g/9i/8i, MySQL, PostgreSql,EFT File Server,HIPPA.

Programming: T-SQL, PL-SQL, C, LINUX(Shell Scripting)

Web Technologies: HTML, DHTML

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Adobe Photoshop, Abode Flash, Mac Office Suite, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

MS SQL Server Developer/SSRS/SSAS/SSIS

Responsibilities:

• Designed a complex SSIS package for importing data from SQL Server 2012
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Hands on experience with database design, designing database architectures such as staging, creating Data-Marts and applying business and calculations for the designs.
• Created packages in SSIS with error handling and different methods of logging in SSIS.
• Implemented data views and control tools for guaranteed data transformation using SSIS.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Developed ASP.Net Custom controls and User Controls and Master Pages using CSS and for providing uniformity among the pages using ASP.NET (4.0).
• Developed solutions using C#, VB.NET, ASP.NET MVC and ADO.NET, Entity Framework.
• Developed HTML prototype of the web pages using CSS, per client specifications.
• Implemented tools for Executives to change the business rules any time of the year.
• Created WCF services to implement the 3-tier service architecture involving data access layer with ADO.Net components, business layer and service layer.
• Responsible for setting up the security and bindings for WCF services.
• Using UML, prepared Use Cases and Class diagrams.
• Client-side validations are done using JavaScript, JQuery in MVC application and Servers side validations with ASP.Net 4.5.
• Successfully deployed SSIS packages with defined security
• Developed logical database and converted into physical database using Erwin
• Proficiently created Reports based on the requirements using SSRS 2012
• Involved to write complex T-SQL queries and Stored Procedures for generating reports
• Involved in Designing, developing and testing the ETL code through Microsoft ETL SSIS tool
• Defined parameters for parameterized Reports using SSRS
• Worked with Report Server and configured to SQL Server 2012
• Extensively worked with OLAP cubes to generate drill through reports in SSRS
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2012
• Created Batch files to run the script in development and production environment
• Developed, Deployed and processed OLAP cube using SSAS. Also implemented Incremental cube processing
• Extensively worked with huge amounts of Complex Data conversion for different types of files and Integrated solutions.
• Designed various complex stored procedures and monitor the stored procedures for maximum performance of the database.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization
• Responsible to monitor performance and optimize SQL queries for maximizing efficiency
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system
• Used stored procedures, created new stored procedures and triggers, modified existing ones, and tuned them such that they perform well
• Tuned SQL queries using execution plans for better performance

Environment: MS SQL Server 2012/2008, ASP .Net, SSAS 2008, SSIS 2008,SSRS 2008, T-SQL,ORACLE.

Confidential - Franklin, TN

SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in SSAS.
• Pulling data daily from OLTP database to OLAP or staging database using the SSIS packages.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).
• Created packages in SSIS with error handling.
• Involved in writing and solving the issues in the complex SQL statements and performing the query optimization.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Hands on experience with database design, designing database architectures such as staging, creating Data-Marts and applying business and calculations for the designs.
• I work on customizations to implement any new business processes as the business changes, build newDAXSSRS reports, build AIF services to integrateDAXwith the external systems like .NET so users can use the services and not use theDAXrich client. This helps save tons of money on theDAXlicenses. I have experience working with and or coordinating the offshore implementation team
• Developed User Interface using Asp.Net and Code behind using C#.Net.
• Analyzed and designed new WPF application using MVVM and Repository pattern, from design to completion, and used the WPF application to interact with SQL database using Data Model, Classes, Contract, Message Contracts and Service with some Common functions.
• Developed web applications using ASP.NETMVC 4.0 architecture with RAZOR view engine.
• Responsibilities included layout of design in building the website using HTML5, CSS3, BOOTSTRAP and various other programs, and keeping up to date with any changes wanted by the client.
• Used JQuery and AJAX to make the User Interface more responsive.
• Used Web Services (SOAP, WSDL) for communicating with other application and components.
• Applied Multithreading techniques for creating high performance applications.
• Prepared class diagrams using UML.
• Worked in ASP.NET Web Forms, ASP.NET State Management, ASP.NET caching features, configuring ASP.NET optimizations, securing ASP.NET web application and used ADO.Net to connect to SQL Server.
• Excel spreadsheet and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Involved in testing QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits with proper ICD - 9 and ICD - 10 and HCPCS/CPT codes.
• Involved in uploading and processing of EDI 278, 276 claims in Portal.
• Prepared sample EDI test sets for files like 276/77, 278,837 and followed HIPAA implementation guide in preparing them.
• Also used BizTalk server as middle ware server to see responses for X 12 files like 835.
• Worked on denied claims for justifications like why the claims got denied and paid zero to the providers to find out the issues.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Building UAT and Test environments using Production backups.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used indexes to enhance the performance of individual queries and enhance the stored Procedures.

Environment: SQL Server 2014/2012/2008 , ASP .Net, MS Excel 2010, QNXT,SSAS, MS SQL Server Reporting Services, MS SQL Server Analysis Services, Erwin,HIPPA.

Confidential - Princeton, NJ

SQL Server BI (SSRS /SSIS/SSAS) Developer

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
• Worked on SSIS transformations like Lookup, Fuzzy grouping, Merge, Union All, Data conversion, Multicast, Pivot & Un-Pivot
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS
• SSIS was the ETL tool used to import data from source tables.
• Wrote Data access components in the form of Web services using ADO.NET with C# as the language.
• Developed application through Win Forms which transfers data in XML format to clients by means of FTP, HTTPS, Email and Web Services on automated scheduled based.
• Implemented .Net Remoting to extract data from middle tier components and service providers.
• Experience in creating complex SSIS packages using proper control and data flow elements
• Designed cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model
• Querying and manipulating multidimensional cube data through MDX Scripting
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Wrote stored procedures to generate account statements for different types of accounts
• Upgrade enhancements, maintenance, production support and bug fixes for the project

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SSAS, SSIS, ASP .Net, T-SQL, SSRS, Windows Server 2003, Oracle 9i.

Confidential, San Ramon, CA

SQL Server / BI Developer

Responsibilities:

• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages
• Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Query Analyzer, SQL Server Profiler, Erwin 7.3/MS Visio 2007

Confidential

SQL Server / SSIS /SSRS /SSAS Developer

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• 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 Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for the purpose of application development
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.