SUMMARY

• 7.7 years of IT experience in the use and development, design, support and migrate of Confidential SQL Server 2005/2008r2 database.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Proficient in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server 2005.
• Extensively worked on system analysis, design, development, testing and implementation ofprojects (SDLC).
• Experienced in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views, table partitioning and other SQL joins and statements.
• Good Understanding of SDLC and Relation Database Architectures,
• Strong SQL Server 2005 Developer Skills including writing user defined functions, views, query writing
• Proactive monitoring of databases
• Experience in creating and maintaining database and its objects
• Good experience in installation and upgrades of/to SQL server 2000/2005 and its service packs, database migrations, backup, recovery and maintenance of SQL Server 2005 databases in Cluster environment.
• Extensive knowledge in SQL Server 2012 Developer Skills including writing user defined functions, views, query writing
• Extensive knowledge on Oracle Forms and Reports.
• Extensive knowledge on .Net
• Extensively worked on Report Server Model, Report Manager
• Extensively worked on SharePoint 2010
• Expertise in writing complex Stored Procedures, Indexed Views and Triggers for data
• Consistency and manipulation.
• Expertise in writing and tuning Transact - SQL (T-SQL) (DDL/DML) Queries.
• Good Knowledge of Normalization/De-Normalization, Normal Form and Data Modeling.
• Proficient in SQL Server technologies such Replication, Index, Functions and Store Procedures.
• Experience in creating Indexes, Views, complex Triggers, effective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Optimization and Performance Tuning.
• Strong experience in using Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005/2008/2012.
• Expertise in creating Packages using SSIS for integration services.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Hands on experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Confidential .NET framework for SSIS packages.
• Experienced in defining Query for generating drill down reports in SSRS 2005, SSRS 2008, SSRS 2012.
• Expert in designing report layout.
• Expert in Experienced in sorting the data, defining subtotals for the reports.
• Proficient in using global variables, expressions and functions for the reports.
• Expert in handling sub reports in SSRS 2005,SSRS 2008,SSRS 2012.
• Experience in Reporting Services (SSRS) 2008/2012, Report Server Model, Report Manager.
• Experience in Oracle Reports
• Experience in OLAP, created Cubes, Dimensions for schemas
• Expertise in upgrading or migrating Analysis Services.
• Proficient in building Star schema and Snow Flake schema depending on business Requirements.
• Expertise hands on Cube Life Cycle
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Expertise in Confidential SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Strong inclination for finishing job before project deadline.
• Excellent communication skills and experienced in client interaction.
• Good experience working in both Inmon and Kimball methodologies.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Languages: C, C++, T-SQL,.Net, Visual Basic

Operating Systems: Windows Server 2003, Windows 2000 advanced Server, Windows NT/95/XP, and UNIX.

Databases: MS SQL Server 2012/2008/2005/2000 , MS Access 97/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Scripting: HTML, DHTML, Shell Scripting, XML.

Reporting Tools: SSRS, SSAS, Crystal Reports, Report Server Model

Data Modeling: Visio 2007 and Erwin 4.1

Application Packages: MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Redmond WA

SQL BI Lead (SSIS/SSRS)

Responsibilities:

• Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
• Provided input to technical solutions in architecture meetings determining project scope, tasks, timeframe, resources to provide project estimates for the BI Team Lead.
• Interaction with a variety of internal and external users to develop technical designs and reviews with the rest of the project team as appropriate.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Designed ETL SSIS packages to process data to target databases.
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Developed Stored Procedures to support ETLs and Reporting.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using Report Server Model for various business users
• Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using Report Server Model. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2012 as assigned.
• Involved in requirements gathering sessions with the offshore team and Business Analysts to understand the business functions
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
• Wrote T-SQL for the retrieval of the data. Identified the Data Source and defining them to build the Data Source Views.
• Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
• Developed Query for generating drill down reports in SSRS 2012. Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Designed, developed and validated the reports layout by using Crystal Reports and ProClarity.
• Created insert and update script to fix data problem, created database objects like View, Stored Procedures, and Functions. Check in Code into TFS (Source Control).
• Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 20012 as assigned.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
• Worked on build star schema and snowflake schema in Analysis Services (SSAS).

Confidential, Cleveland, OH

Lead /Sr. SQL BI (SSRS)

Responsibilities:

• Tuned the Database to increase the performance for the faster retrieval of the data.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Extensively used T-SQL to produce desired results for users.
• Developed multiple join statements to retrieve data from several tables and views.
• Usage of CTE’S for efficiency and faster execution time
• Developed complex T-SQL Queries and SQL Scripts for efficient data load, based on complex Business rules.
• Extensively worked on SQL Server 2012 Management Studio
• Created several SSIS jobs and packages and executed those tasks
• Created several reports from oracle Source.
• Worked on creating cascading parameters on reports.
• Develop and deliver dynamic reporting solutions using SQL Server 2008/2012 Reporting Server Model.
• Extensive experience working with Change Data Capture (CDC).
• Validating SQL Server 2012 SSRS reports.
• Created Income statement and other financial reports using SSRS.
• Extensively worked on drill-down and drill-through reports.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS
• Worked Interactive sorting on reports.
• Extensively worked on expressions and filters.
• Worked on building Dashboards in SSRS.
• Expertise in dealing with primary control for Tablix reports
• Extensively worked on SQL Server 2012 SSRS and SSIS
• Created several reports using SSRS 2012
• Deploying reports into ReportServerModel and involved in subscriptions
• Experienced in troubleshooting and repairing SharePointfailures from both the server side and client side
• Extensively worked on conversion of Crystal reports to SSRS
• Extensively worked on Store procedures, functions and used them in developing crystal reports
• Extensively worked on cube Life Cycle Process
• Hands on Power view, Power Pivot
• Extensively worked on Inmon and Kimball methodologies
• Extensively worked with offshore teams on creating reports and packages

Environment: MS SQL Server 2005/2008 r2/2012, MS SQL Server Reporting Services 2005/2008/2012 r2, T-SQL,PL/SQL, SSIS 2005/2008/2012 r2,Oracle,IBM Lotus.

Confidential, Dayton Beach, FL

SQL BI (SSRS/SSIS) Developer

Responsibilities:

• Tuned the Database to increase the performance for the faster retrieval of the data.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Used SQL Profiler to view Indexes performance to eliminate table scan.
• Extensively used T-SQL to produce desired results for users.
• Developed multiple join statements to retrieve data from several tables.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
• Experience monitoring the Change Data Capture Process.
• Involved in all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Created SSIS process design architecting the flow of data from MS Access to MS SQL Server 2005.
• Created ETL (.DTSX files) packages using SSIS to Validate, Extract, Transform and Load data to Data warehouse databases, Data mart databases.
• Designed ETL SSIS packages to process data to target databases.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Coordination with off shore teams in testing.
• Experience with my Oracle support team.
• Extracting data from Oracle Source
• Worked on building dashboard reports
• Extensively worked on SSRS 2008.
• Expertise in creating cascading parameters, expressions, filters, charts, tabular reports, matrix reports in SSRS 2008
• Developed standard reports, sub reports and charts using crystal reports.
• Extensively worked on converting of crystal reports to SSRS reports.
• Extensive worked on Tablix control reports in reporting services
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure on levels of reports.
• Based on the OLAP reporting needs, developed complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies.
• Expertise in SharePoint and Power Pivot.
• Expertise in working Kimball methodologies.

Environment: MS SQL Server 2005/2008 r2, MS SQL Server Reporting Services 2005/2008 r2, T-SQL, SSIS 2005/2008 r2, Oracle, Visual SourceSafe, Win 2003 Advanced Server.

Confidential, San Jose, CA

SQL BI Developer

Responsibilities:

• Participated in upgrading from MS SQL Server 2000 to MS SQL Server 2005.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored Procedures and Triggers.
• Worked on Agency Management System for creating Stored Procedures and Triggers.
• Configure the SSIS Package for run time Parameters and Configuration file.
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Tried to in corporate the DTS Packages into SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Involved in the design of transformation strategy from OLTP to OLAP Interfaces using SSIS and the new SCD Task.
• Scheduled Jobs to call ETL/SSIS packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Succeed.
• Rewrite old Crystal reports by adding new business requirements using SSRS
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
• Created Income statement and other financial reports using SSRS.
• Deploying reports to SharePoint server.
• Worked closely with the DBA for successful preparing, planning and installation of the upgraded software and all its new tools.
• Upgraded SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Basic idea in designing and developing the quality GUI application by using VB.Net.
• Prepared the Connectivity for the database and front-end by using .net technology.

Environment: SQL Server 2005/2008 r2, ETL/SQL Server Integration Services (SSIS), MS Excel 2003, Electronic Data Interface (EDI), Management Studio, MS SQL Query Analyzer, SQL Profiler .Database Tuning Advisor, SSRS and SSAS

Confidential, Boston, MA

Database Consultant

Responsibilities:

• Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month
• Created system for capturing, reporting, and correcting error data.
• Provide on-call support to production system to resolve any issues.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Gather requirements and design of data warehouse and data mart entities
• Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record
• Implemented the lookup transform extensively to populate the unmatched entries to dimension table
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Extensively worked with SSAS for processing different cubes
• Conduct code walkthroughs and review peer code and documentation.
• Worked on different file formats(fixed width, ragged right and delimited data sets)
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

Environment: SQL Server 2005, Confidential Business Intelligence Development Studio, T-SQL, SSIS, SSAS, SSRS, ERWIN

Confidential, Benton Harbor, MI

SQL Developer/SSIS/SSRS

Responsibilities:

• Created several prototypes using MS Access.
• Created several ABI Reporting databases, tables and stored procedures using SQL Server 2005.
• Wrote different complex SQL queries including Inner, Outer Join and Update Queries.
• Developed reports for payment and BI Count to show organizational and seasonal comparison.
• Developed several data mapping (DB2 to SQL Server 2005) documents and data mining (SSIS transformation) documents.
• Created several SSIS jobs and packages and executed those tasks.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using SQL Server 2005 Integration Services (SSIS).
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration.
• Developed windows schedule tasks for different data pulls and directly populate data to SQL Server by creating several ODBC connections.
• Transformed data from various data sources using OLE DB connection by creating various DTS /SSIS packages.
• Installed and Configured SQL Server 2005 and alsoUpgraded the existing database to SQL Server 2005.
• Created several test cases and involved in system testing.
• Built SSIS Packages for Processing cubes and Dimensions.
• Created Tabular and Matrix reports using SSRS.
• Responsible to provide production support to the client.

Environment: MS SQL Server 2005, SSIS, SSRS, Windows Server 2003/2000/NT4.0, MySQL, Oracle, MS Access 2003, System Monitor/Performance Monitors, Performance Tuning, Clustering, MS Office 2003/2007.

Confidential, Madison, WI

SQL Server 2005 Developer

Responsibilities:

• Collected the user and system requirements and write technical specifications.
• Actively involved in Normalization & De-normalization of database.
• Designed and developed a Front Office database system.
• Create tables, Views, Clustered & Non-Clustered Index, user defined data types, and user definedFunctions
• Create Joins and Sub-Queries for complex queries involving multiple tables.
• Mentor front end users about SQL Queries.
• Involved in Administration of the SQL Server by creating Users & Login ids with appropriate
• Roles & grant privileges to users and roles.
• Created & used stored procedures for database transactions in SQL Server
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL Queries and Stored Procedures
• Created automatically running Stored Procedures and Triggers
• Create and customize DTS packages and used DTS to load data from difference sources.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance ofDatabase servers
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Environment: Windows 2000 Advanced Server, MS SQL Server 2005, MS Outlook, TSQL, Erwin, ETL and DTS.