SUMMARY

• Over 7+ years of IT experience in Analysis, Design, Implementation and Administration of Business IntelligenceSolutions wif Microsoft SQL Server 2005/2012/2008 wif various business domains like Financial, Banking, and Insurance Sector
• Experience in MS SQL Server 2012/2008/2005 wif 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 wif 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 theirsults 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 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, TEMPeffective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
• Excellent verbal and written communication skills combined wif 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 wif 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

Sr. MS SQL Server Developer/SSRS/SSAS/SSIS

Responsibilities:

• Designed a complex SSIS package for importing data from SQL Server 2008
• Used ETL to implement teh slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS wif 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 teh data into Destination.
• Successfully deployed SSIS packages wif defined security
• Developed logical database and converted into physical database using Erwin
• Proficiently created Reports based on teh requirements using SSRS 2008
• Involved to write complex T-SQL queries and Stored Procedures for generating reports
• Defined parameters for parameterized Reports using SSRS
• Worked wif Report Server and configured to SQL Server 2008
• Extensively worked wif 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 2008
• Created Batch files to run teh script in development and production environment
• Developed, Deployed and processed OLAP cube using SSAS. Also implemented Incremental cube processing
• 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 teh Subscription Reports wif teh Subscription Report wizard
• Involved in teh 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, 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 on a daily basis from OLTP database to OLAP or staging database using teh 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 wif error handling.
• Extensively used SSIS Import/Export Wizard, for performing teh ETL operations.
• Worked wif 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 wif users in training and support and also has experience in incremental data loading.
• 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 wif 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 teh claims got denied and paid zero to teh providers to find out teh 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 teh database.
• Wrote store procedures to generate account statements for different types of accounts
• Worked wif T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used indexes to enhance teh performance of individual queries and enhance teh stored Procedures.

Environment: SQL Server 2008, 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 halped in teh Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment
• Worked wif 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 wif error handling
• Worked wif different methods of logging in SSIS
• Experience in creating complex SSIS packages using proper control and data flow elements
• Designed cubes wif star schema using SQL Server Analysis Services (SSAS)
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in teh data
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from teh Unified Dimensional Model
• Querying and manipulating multidimensional cube data through MDX Scripting
• Experience wif 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 teh database
• Wrote stored procedures to generate account statements for different types of accounts
• Upgrade enhancements, maintenance, production support and bug fixes for teh project

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i.

Confidential, San Ramon, CA

SQL Server / BI Developer

Responsibilities:

• Created scripts to verify and reconcile teh migrated data from legacy system to SQL Server.
• Involved in gathering Business Requirement after interacting wif teh 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 teh 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 teh database.
• Performed Unit testing for teh 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 Developer

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for teh 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 wif several Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for teh 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 teh reports using teh Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues wif teh databases/servers on a real-time basis

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