SUMMARY

• Around 8 years of extensive experience in IT in Database System Analysis, Design Implementation and Administration of MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014 in Production, Test, Development and Replication & Cluster Server Environments.
• Understanding in Installing, Upgrading, Troubleshooting and Configuration of MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014, UNIX Database.
• Experience on working with Production and 24/7 on call environments and documenting all Database architecture according to the established standards.
• Extensive work experience on system analysis, design, development, testing, and implementation of projects with full SDLC (Software Development Life Cycle).
• Extensive experience and in depth working noledge in various SQL Server tools and IDE to work with Database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio and Query Analyzer.
• Excellent Experience in SQL Server administration using Service Broker, Replication and Log shipping.
• Experience in creating and maintaining SQL Clustering, Optimization, Backup, Restore, Security and Disaster Recovery.
• Expert in Creating tables, views, user defined data types and indexes.
• Excellent noledge in RDBMS concepts and constructs along with Object creation such as Database, Tables, Normalization, User Defined Functions, SPROC, Views, Cursors and Triggers.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, Backup and Recovery.
• Hands on Experience in writing complex stored procedures, Indexed Views and also creating and Updating tables for Data consistency and Data manipulation by executing DBCC commands.
• Expert in designing ETL data flows using SSIS creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management, Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Comprehensively Involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with .Net, Import/Export data, Bulk insert and BCP.
• Migrated Organization, Orders, Adjustments, Objectives, and data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Migrated and recreated existing Dimensions and Cubes using Star Schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Solid experience in converting legacy MS Access and Crystal Reports to Reporting Services 2008/2008 R2.
• Good experience in Creating, Populating and maintaining Data marts. Thorough noledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, and Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Experienced analyst to build, deploy, document and enhance interfaces into and out of demand planning system, and run processes on that system.
• Experience in depth noledge of medical terminology and interpret medical records in Facets, HEDIS, etc.
• Experience in HEDIS on Adhered to establish procedures for scheduling, requesting, and reviewing records while on - site at provider offices and hospitals.
• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Build, deploy, document and enhance interfaces into and out of transactional demand planning system using MS tools and good understanding on Demand Planning System.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Experience in developing User reports and Management reports using MS SQL Server Reporting Services.
• Worked extensively with SVN - Subversion to make changes to code without overwriting the existing code
• Organized professional with excellent oral and written communication skills, fast learner and also adapt quickly new technology with ability to take new roles in minimum time and little training. Ability to work individually as well as in a team with excellent problem solving and trouble-shooting capabilities and ability to think to outside the box.
• Actively involved in AGILE SCRUM work environments.
• Worked extensively with Agile technologies for project processes
• Worked exclusively with Cognos designed to enable business users without technical noledge to extract corporate data, analyze it and assemble reports.
• Worked Exclusively with BI Dashboard development for data visualization and key performance
• Good understanding of Health Care, Financial, Banking & State Government.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2005/ 2008/2008 R2/2012/2014, MS-SQL Server 2012 and 2014, MS Access, Oracle 8i & 9i, Sybase.

Operating Systems: Windows XP, 2003/2000, NT, UNIX, Linux.

DBA Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, Query Analyzer, SQL Profiler, Enterprise Manager, Visual Studio .Net 2005, Oracle 11g/10g/8i/9i,ODBCOLAP, MOLAP, ROLAP, OLTP, DBCC and BCP.

Reporting Tools: Crystal Reports, Reporting Service (SSRS) 2000/2005, Cognos 10

ETL Tools: Autosys,Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SharePoint, Erwin & Visio

OLAP Tools: SQL Server Analysis Services (SSAS).

Programming Language: C,C#,C++, PL/SQL, T-SQL, MDX, DMX, Visual Basic 6.0,VB Script,VB.Net & ASP.Net

Utilities/Applications: UML, MS-Word (98/00/XP), MS-Excel (98/00/XP), MS-PowerPoint (98/00/XP), Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Virginia

SQL/BI/SSIS/SSRS Developer

Responsibilities:

• Actively involved in gathering and analyzing the user requirements.
• Creating complex stored procedures, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Generating multiple enterprise reports from SQL Server Database (OLTP) including various reporting features such as groups, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Creating different Parameterized Reports (SSRS 2005/2008/2008 R2) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Developing SSIS packages to generate different types of flat file reports like fixed width file, pipe delimited file and CSV files.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Responsible for determining the Mapping bottlenecks with Informatica and fixing the issues by tuning the Mappings for better performance.
• Using SQL Maintained and enhance the existing data warehouse, exports, and reports.
• Used Informatica Debugger to troubleshoot data and error conditions.
• Involved in planning, defining and designing database using Erwin on Business requirements.
• Involved in installation and configuration of MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP sources like MS SQL Server 2000, Teradata, Oracle Database, Text Files, Excel and Access to OLAP systems (SQL 2005/2008) and scheduled jobs to call the packages and stored procedures.
• Worked extensively with SSAS
• Participated in Design discussion and working on relational table designs
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Used the SSIS Script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Conditional Split and Derived column.
• Wrote T-SQL queries, stored procedures and used them to build packages.
• Responsible for query optimization to improve the quality of software by using SQL Profiler.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler.
• Worked exclusively with Dashboard development to include a customizable interface and the ability to pull real-time data from multiple sources.
• Worked exclusively with Oracle 10g for the Providers data depending on the client requirements
• Worked exclusively with Cognos 8 and Cognos 10 designed to enable business users without technical noledge to extract corporate data, analyze it and assemble reports.
• Responsibilities:
• Interact with business analysts, business users in understanding the requirements and develop complex business logic to extract the required data.
• Create data extracts to send the data across to different vendors (XML, Pipe Delimited, Excel etc)
• Using SQL profiler identified slow running queries and tuned them using Dynamic Management Views.

Environment: MS SQL Server 2008/2012/2014, ORACLE, TrizettoFacets, Windows XP, Windows Server 2012, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Data Tools, MS Excel, Flat File, SQL Profiler, XML, Source Version Control, Cisco Enterprise Scheduler, Service Now, Zephyr, JIRA, Confluence.

Confidential, Waukesha, WI

SQL Server Developer/SSAS/SSRS Developer

Responsibilities:

• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Used to work on Installation, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2008R2/2008/2005 on VM Ware Clustered and Standalone Environments
• Used ASP.Net coding and C# to call the Stored Procedures created with T-SQL
• Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Designing Xcelsius Screens using the build in components like Pie charts, Tabs, Panels, Filters and so on.
• Displaying the components using the Dynamic Visibility logic.
• Developed WebI reports
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)
• Involved in error handling of SSIS packages by evaluating error logs
• Successfully extracted transformed and load data into data warehouse
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports(SSRS) according to business requirement
• Created reports by dragging data from cube and wrote mdx scripts
• Used SSIS 2008 to create ETL packages(.dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan.
• Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, indexes, Triggers.
• Extensively involved in writing database scripts.

Environment: Windows 2005 R2, 2007, 2008 MS SQL Server 2003/2005/2005 R2, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS) SQL Server 2008, SQL Server Management Studio (SSMS), Sybase BIDS, Oracle, .net, Power Designer, Microsoft Outlook, Red Gate, Team Foundation Server, Oracle 11g, IIS, VB.Net, Erwin, MS Excel, XML, SQL Profiler

Confidential, Long Beach CA

BI Developer/SQL Server

Responsibilities:

• As a BI developer I was actively involved in the all the team meetings and gathering business requirements from stakeholders and providing a best possible solutions based on the data perspective as documenting the process as required.
• ODS team was involved in upgrading their databases from SQL Server . I suggested techniques for Performance Tuning their databases and successfully implemented new techniques available in SQL 2008 to increase in performance such as index fragmentation, studying execution plans and using a database tuning tool to increase performance.
• Involved in writing T-SQL programming for inserts, updates, deletes, functions, triggers, stored procedures based on the requirement and completing the task as given. Also involved in analyzing the SQL code and doing analysis for database integrity and data validation.
• Managed refresh requests, data quality and data validation requests from other teams and worked on those requests and solved them using SQL Server 2008 as a tool.
• Trouble shooting SSIS packages, upgrading to SSIS 2008, Fine Tuning of packages and also building some AdHoc packages to do the data load from ODS to other source servers.
• Well versed in SSIS development by building new jobs and packages based on the business requirement and also optimizing the existing packages to increase performance of these packages which are built previously.
• Involved in solving database tickets by using SQL server by other business users’ .Successfully implemented the SQL Server 2008 Upgrade for MI, TX and WA.
• Also wrote test cases based on the changes that would effect the database when they are made in production. Involved in DQ and DV analysis for the business and figure out the data discrepancies and issues and fix those issues.
• Created an ETL audit reports, Health reports for various states in the business based on the business requirement using SSRS.
• As a data analyst prepared and analyzed test cases for ETL jobs that run daily in the business and also documented them and updated in TFS.
• Used SharePoint 2010 and TFS (Team foundation Server) to upload shared documents prepared by me. Also used Excel 2010 to build some reports upon request by the business and also used Autosys to run some of the critical jobs to fix them.
• Created Various types of reports like Simple, Drill down Reports, and Grouped Cross Tab using BO for better analysis
• Created Web intelligence reports by using the various business objects functions
• Developed Xcelsius dashboards, based on WebI reports.
• Used Live Office & QaaWS to connect to the WebI Universe and to bring the data into Xcelsius.
• Implemented aggregated data into Crystal Xcelsius and created highly interactive and user friendly dashboards with visual effects.

Environment: MS SQL Server 2008, Oracle 11g, SharePoint 2010,SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tabular, Excel Powerview, Powerpivot, Performance Point, MDX, Report Builder, Oracle 8i,9i, MicroStrategy Desktop 9, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server.

Confidential, Baton Rouge LA

SQL Server/SSIS Developer

Responsibilities:

• As a SSIS Developer/ETL Developer for dis project well versed in creating and maintaining and writing code for SSIS jobs and scheduling them.
• Involved in developing logical and physical data models using ERWIN tool.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Provide query performance monitoring and tuning recommendations, cost estimates, tuning using SQL P/A, DB2 Explain utilities.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Created queries for generating drill down reports in SSRS.
• Formatted the reports using the Global variables, expressions and Functions.
• Optimized SQL statements for customer summary reports.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Understanding the client requirement and maintaining Data quality, Volume and health of databases.
• Involved in creating SSIS packages forloadingdata from data source (SQL database) to staging database.
• Created document for Self-Service Deployment and Execution process for SSIS packages.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Proficient on and designing Dimensional modeling or Kimball/Inman methodology and Data Warehouse using Erwin in Star and Snowflake Schemas.
• Built SQL queries for the reporting tool (COGNOS10) based on the business requirements for the client.
• Well versed in monitoring and maintaining reports in COGNOS 10 which were using in dis project.

Environment: MS SQL Server 2008/2005, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS),MS SQL Server, T-SQL, Data Transformation Services (DTS), Analysis Services (SSAS), Reporting Services (SSRS), Windows SharePoint services 3.0, Integration Services (SSIS), ER/Studio, Query Analyzer, Business Objects, SQL Profiler, Enterprise Manager, Excel, Flat File, Oracle 10g,DB2, Erwin C#,VB.Net,ASP.Net.

Confidential 

SQL Developer-SSRS Developer

Responsibilities:

• Installed and configured SQL Server 2000/2005.
• Designed and developed the databases.
• Actively participated in logical design of database design to meet new product requirement using ERWIN.
• Wrote and modified stored procedures to implement the complex business needs for generating new customer number, account no, increasing, decreasing and setting credit limit as per business policies, updating user profiles, transaction processing, generating messages with code encryption
• Configured the DTS packages to run in periodic intervals.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Updated the statistics info for both the old and new servers.
• Provided back-end support for functional testing and performance testing.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViews
• Modified database structures as directed by developers for test/develop environments and assist withcoding.
• Developed Query for generating drill down and drill through reports in SSRS 05.
• Writing stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Facilitated simplified access of database for end users using demoralized views and created triggers on them to maintain to database integrity
• Created tables, views, triggers, stored procedures and indexes.
• Created integrity rules and defaults.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Created Crystal Reports on daily, weekly and monthly basis for manager’s review.

Environment: SQL Server 2005, T-SQL, DTS Designer, Windows 2000, Oracle, DB2, Flat Files.MS-Office, Ms-Excel, VSS, BIDS