SUMMARY

• 8 Years of experience with MS SQL Server 2000/2005/2008 R2/2012/2014 as a back end developer in financial, healthcare, Implementation, Debugging and Testing of software applications and retail companies.
• Experienced in Database design, Coding, unit testing and Implementation.
• Exposure to Health Information Exchange (HIE) integration and Electronic. Medical Records (EMR) integration like Epic, eClinicalWorks
• Proficient in creating Index, Views, Complex Stored Procedures and appropriate User defined functions.
• Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
• Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• WroteTeradata Macrosand used various Teradataanalytic functions.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Developing reports onSSRSon SQL Server ( 2000/2005/2008 ). Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Experience in creating database objects to create reports and troubleshooting.
• Experience in creating Ad - hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.
• Involved in UAT and Integration testing with QA team.
• Participated in understanding of latest industry trends and technologies.
• Ability to work on fast paced work environment.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training /supporting end users.

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

SSAS Developer

Responsibilities:

• Evaluate trading partner requests for new and modifications to existing applications and programs/processes/maps.
• Participate in project meetings, providing input to project plans and providing status updates.
• Creating workflows to extract data from SQL Server and Flat File Sources and load into various Business Entities.
• Monitoring of processes to automate the process of loading data into data targets and monitoring scheduled daily/weekly/monthly jobs.
• Provide status updates on all assigned tasks using the department’s service request tracking tool and TFS project tracking.
• WroteTeradata Macrosand used various Teradataanalytic functions.
• UsedTeradata utilities fastload, multiload, tpumpto load data
• Exposure to Health Information Exchange (HIE) integration and Electronic. Medical Records (EMR) integration like Epic, eClinicalWorks
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• DesignedDimensional ModelingusingSSASpackages for End-User.CreatedHierarchiesin Dimensional Modeling.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Follow existing source code management and version control processes for all coding efforts.
• Experience working in formal life cycle methodologies i.e. agile.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Created Ad-hoc reports, drill down and drill through reports and cross tab reports.
• Served as a SSRS Reports Developer and SQL Server Developer in support of Service Management System.

Confidential - Richardson, TX

SSAS Developer

Responsibilities:

• Played an active role during the requirements gathering, analyzing and designing of the system.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created logical data model using ER/Win 4.0.
• Development of large-scale test databases and associated maintenance scripts.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Exposure to Health Information Exchange (HIE) integration and Electronic. Medical Records (EMR) integration like Epic, eClinicalWorks
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Development of custom scripts and stored procedures for data import and manipulation
• Configuring, tuning, and optimizing SQL Server 2005.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Strong RDBMS concepts including expertise in pl/SQL queries likeDML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, andCursorsetc.
• Experienced in programming as anSQL Developerin Analysis, Design, Data Modeling(logical and physical), and Implementation of Business Applications using the Oracle Relation Database Management System(RDBMS)
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations usingMDX.
• Defining relationships betweenDimensionsandMeasure groups. Involved in the design and development of the SSAS cubes andMDXqueries
• Worked on Data modeling, creating star and snowflake schemas in SSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created horizontal partitioning of data for different file groups.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Create parameterized Reports using Charts, Cross-Tab and Sub-report types.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/20, TSQL, Pl/SQL, Visual Studio 2008, SharePoint 2007/2010, Lotus Notes, SSRS, SSIS, OBIEE, Informatica, Erwin.

Confidential, Wellesley Hills, Massachusetts

SQL BI Developer

Responsibilities:

• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Experience in parsing high-level design specification to ETL coding.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• DevelopedMulti dimensional Objects(Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Developed MDX Queries against SSAS cubes to generate reports.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Interacted with vendors, developers and customers to manage the business requirements.

Environment: Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2005/2008/2012, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008, Sharepoint 2007/2010, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

Confidential, Northfield, IL

SQL BI Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and created the table schema andstored proceduresthat will be used in Data QC.
• Designed and developed theData QC Maintenancewebsite that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential, Beaverton, OR

SQL BI Developer

Responsibilities:

• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential

SQl BI Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Environment: MS SQL Server 2008, MS Access, MS Excel, T-SQL