PROFESSIONAL SUMMARY:

• Microsoft Certified Professional with 9+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2014/2012/2008 R2/2008/2005/2000 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Experience in SQL Server DTS and SSIS(Integration Service) package design, constructing &deployment.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T - SQL Scripts MS SQL.
• Designed and developed DB2 OLTP and OLAP databases in support of Service Oriented Architecture solutions.
• Developed procedures to migrate legacy systems into the next generation systems.
• Defined data standards and developed the data architecture by providing integrated data.
• Experience with T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience in Using multiple join statements to retrieve data from multiple tables.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports. Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• ConfiguredSSISpackages usingPackageconfigurationwizard to allow packages run on different environments.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS
• Worked with Financial companies for application related pricing and security applications
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema
• Experience in multidimensional databases with demonstrated ability to create calculated members and MDX scripting
• Proficient in buildingCubes,definingReferenced Relationshipsand creating Hierarchies in SSAS
• Expertise in creatingCell Level Securityin cubes usingSSAS.
• Expert in uploading SQL Server Reports on to the report manager and organize them in folders and worked with delivering the reports using ‘pulled’ and ‘pushed’ methodologies.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Built and wrote MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 /2010/2012 Analysis Services Business Intelligence (SSAS, SSRS)
• Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008/2010/2012
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Business Intelligence Tools: Microsoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), ), Cognos 10, 8 (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer), BIDS, Tableau.

ETL Tools: DTS, SSIS

Reporting Tool: SSRS, Crystal Reports, Business Objects, TFS, VSS

Programming Languages: T-SQL, PL/SQL, .Net, MDX, DAX, HTML

Databases: MS SQL Server 2005/2008 R2/2012/2014, Oracle 9i/10g/11g, SQL

Data Modeling Tool: MS Access, DB2/UDB, Mainframe

Operating System: Erwin, Microsoft Visio,performance point server, Power Pivot. Microsoft Windows 95/98/2000/2002/Vista/Windows 7/Windows 8/

Backup Tools: Red Gate, Lite Speed, VERITAS

PROFESSIONAL EXPERIENCE:

Confidential, OH

Sr. BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Designed and developed DB2 OLTP and OLAP databases in support of Service Oriented Architecture solutions.
• Had an experience on Microsoft Office PerformancePoint Serverand power pivot for planning and budgeting component directly integrated with excel. Had an experience working with flat file to access the structure of the data and manipulate it.
• Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Created SSIS packages to migrate data from Oracle 8i to MS SQL Server 2005.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created SQL server Reports using SSRS 2005 for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Set up hierarchies and defined Scope of Analysis in the Universe for providing drill down/ drill through options in the reporting environment.
• Created Queries for generating drill down reports in SSRS 2005.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created Condition Objects in the Universe to restrict data
• Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
• Created simple query filters, prompted filters and complex filters to restrict data in reports.
• Collected business requirements, designed data maps and data models. Created Internal and External Design Documents and Transaction Definition Documents.
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Created several stored procedures, triggers, views.
• Tuned lots of ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Environment:MS SQL Server 2012/2008R2, SSRS, SSIS, ADO, T-SQL, Stored Procedures, Microsoft office Performance Point Server and Power Pivot, XML, IIS 6.0, MS Visual Studio 2010, DTS, Crystal Reports 9.0

Confidential - Farmington Hills, MI

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Designed and developed DB2 OLTP and OLAP databases in support of Service Oriented Architecture solutions.
• Developed procedures to migrate legacy systems into the next generation systems.
• Defined data standards and developed the data architecture by providing integrated data.
• Had an experience working with flat file to access the structure of the data and manipulate it.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules usingT-SQL
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations

Environment:SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, Microsoft office Performance Point Server and Power Pivot, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Long Beach, CA

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data
• Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Monitored SQL serverperformance using profiler to look for dead locks, blockings and captured long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing through Profiler.
• Created indexes to speed the execution of data retrieval queries, rebuilding them if necessary and often checked for any outdated statistics
• Scheduled the backups for Databases and performed restoration operations when needed.
• Used log shipping for synchronization of databases and documented every change.
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute sql flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix (cross tab),conditional, list items, charts formerly in cogon’s reports and SAP BO

Environment: MS SQL Server 2008R2, DB2, Teradata, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Agile Scrum Methodology, Microsoft Access, Windows 2003/XP, XML, IIS.

Confidential

MS SQL Server Developer

Responsibilities:

• Created tables, views, indexes based on the requirements
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Involved in designing of Conceptual Logical Modeland Physical Model.
• Created new database objects likeProcedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrityand additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of bothT-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables

Environment:SQL Server 2000/2005 and 2008 management studio, DTS, SSIS, SSRS, Visual Studio 2008, MS DOS Batch scripting and COBOL

Confidential

Junior SQL Developer

Responsibilities:

• Installing and Configuring of SQL Server2005/2000 0n windows 2000/NT OS.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Managing of users including creation/alteration, grant of system/database roles and permission on various database objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries

Environment: Windows 2000, SQL Server 2000/ 2005, Enterprise Manager, SQL Profiler, DTS, T-SQL,BCP, Replication.