SUMMARY

• 7 plus years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC, using MS SQL Server 2008R 2/ 2008/2005/2000, DTS/SSIS, Reporting & Analysis Services, MY SQL Server.
• Extensive SQL Development experience in a healthcare environment with a strong understanding of healthcare data & analytics.
• Extensive experience with different phases of project (project initiation, project requirement and specification gathering, designing system, coding, testing, and debugging new and existing client - server based applications).
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Extensive Experience with designing multi table relational databases with proper enforcement of relational constraints.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin 7.0.
• Experience in Data Warehousing designs in Star and Snow flake Schemas.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.
• Skilled in SQL 2005 Business Intelligence tools, Data Warehousing and ETL processes & strategies using SQL server Analysis and Integration Services.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Extensive experience in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts & column report.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Expertise in database optimization using tools like Database engine Tuning Advisor, SQL profiler, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.

TECHNICAL SKILLS

• MS-SQL Server 2008R 2/ 2008/2005/2000 /7.0
• Oracle 8i/9i/10g
• MS Access
• T-SQL
• PL/SQL
• C
• C++
• C#
• HTML
• XML
• Java
• ASP .NET
• VB .NET
• Windows 98/2000/2003/ XP/NT/Vista
• Windows 2000Advanced Server
• Windows 2003 Enterprise Server
• MS SQL Server /7.0
• MSSQL Server Reporting Services 2008/2005/2000 (SSRS)
• MSSQL Server Analysis Services 2008(SSAS)
• MSSQL Server Integration Services 2008(SSIS)
• Data Transformation Services (DTS)
• ODBC
• OLTP
• OLAP
• SQL Server Management studio (SSMS)
• Erwin 7.2/4.5/4.0
• MS Visio 2003/2007
• Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, NYC

MS SQL Server/SSIS/SSRS/SSAS Developer

Environment: MS SQL Server 2008, T-SQL, SSIS packages, TFS, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, Windows 2008 server

Responsibilities:

• Developed ETL Packages using SQL Server 2008 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Created standard & Data driven report subscriptions. Created report snapshots and cache for better performance.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Created & modified a number of existing stored procedures based on the changes made to some existing tables.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created both automated and manual reports using SSRS (SQL Server Reporting Services).
• Configured report builder and trained business users so that they could create reports from the report models I created.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.

Confidential, Boston, Massachusetts

SQL Server Developer/SSIS/SSRS Developer

Environment: Windows Server 2003, MS SQL Server 2008,Business Intelligence Development Studio (SSAS, SSRS & SSIS), TFS, MS Office Access 2003, Excel, Erwin4.0 and Visio.

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the new system.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Successfully migrated data from Microsoft SQL Server 2000 to Microsoft SQL Server 2008 using SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Created business critical KPIs usingSQL ServerAnalysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Developed and designed cubes with around 45 dimensions, about 25 Measures and 20 calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions andKPI.
• Extensively involved in theSSASstorage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL
• Used Data Defractor tool to normalize semi-structured Spreadsheets, fed it into the SSIS pipeline in the form of normalized output of factual data and contextual metadata.
• Identified the Measures and Dimensions from the Excel Sheet according to the requirement using Data Defractor Tool.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.

Confidential, Chicago, IL

SQL Server Developer (SSIS, SSRS)

Environment: MS SQL Server 2005, T-SQL, SSIS packages, VSS, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, Windows 2003 server

Responsibilities:

• Created reports from prototype Analysis Services Cube using SQL Server 2005 Reporting Services.
• Deployed and configured reports in SharePoint Server.
• Created standard & Data driven report subscriptions. Created report snapshots and cache for better performance.
• Involved in Installing SQL Server 2005 and creating users and Groups.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Created & modified a number of existing stored procedures based on the changes made to some existing tables.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created both automated and manual reports using SSRS (SQL Server Reporting Services).
• Configured report builder and trained business users so that they could create reports from the report models I created.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Developed ETL Packages using SQL Server 2005 Integration Services to migrate data from Oracle data source into a SQL Server 2005 database.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Confidential - Sunnyvale, California

SQL/SSIS/SSRS/SSAS Developer

Environment: Windows XP/2003 Enterprise edition, MS SQL Server 2005/2008, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Responsibilities:

• Extracted required mapping fields from different sources (schema, CDW) to Sales Force Warehouse for Staging Table.
• Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force.
• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id’s, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.
• Developed Store Procedure and Staging table for data push from CDW to Sales Force.
• Preformed QA Testing for all the Store Procedures to validate the sales results.
• Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created Packages by testing and Cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Used sub reports functionality for complex report calculations.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Documented all database objects, procedures, views, functions & packages for future references.
• Performed all QA testing and match results for different environments.
• Documented all old and migrated Store Procedures and scripts for future reference

Confidential, Southfield, MI

MS SQL Developer/SSRS, SSIS Developer

Environment: T-SQL, Enterprise manager, VSS, ERWIN, MS Office & Windows 2K platform SQL Server 2005 Enterprise Edition, Microsoft Visual Studio, C#,ASP.Net, SQL Server Reporting Services, SQL Server Integration Services, SQL Profiler, SQL Server Agent, SQL API, XML, Windows Server 2003, MS Visio, IIS 6.0.

Responsibilities:

• Responsible for Data Modeling based on the client requirements.
• Prepared the Technical and Function specifications based on the project requirements.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.
• The SSIS Packages include, a Master Package which executes a number of Child Packages.
• The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Modified stored procedures to meet current design and used them in SQL Server.
• Developed queries in Data Warehouse in OLTP/OLAP environment.
• Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Modified web pages to do database inserts, deletes, modify.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Created report models from OLTP & OLAP.
• Trained 10 business users so that they can create reports from the report model I created.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Involved in Development, Review and testing of the new system by implementing business rules and transformations.

Confidential

JR SQL Developer

Environment: SQL Server 2000, VSS, VB Script, DTS, MS Access 2000/2003, Visual Studio 2003

Responsibilities:

• Created new tables, wrote static/dynamic stored procedures and some user defined functions for Application Developers.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity and business rules.
• Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
• Generated summary reports like Tabular, Matrix, Drill down and Drill through using Report builder.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Query Plan (Graphical/Text) and Statistics I/O.
• Involved in development, support, document reviews, testing and integration of the system.
• Created and maintained various additional indexes, additional intermediate tables for faster and efficient reports retrieval.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files, and Access.
• Worked on Log Shipping, Replication to restore Database backup.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Used linked tables, pass through queries and many other MS Access features like Macros, Reports etc.