SUMMARY:

• A SQL Server Developer with around 8 years of experience in the IT industry, with Microsoft SQL Server 2000/2005/2008 R2/2012, SSIS/SSRS/SSAS for both OLTP and OLAP (Data warehousing) environments.
• Experience in BI Suite for ETL Development DTS/SSIS, Reporting (SSRS) and Analysis SSAS, Performance Point Server, MOSS and Dashboard reporting.
• Experience in designing Database Models using MS Visio and ER - Win for both Relational and dimensional modeling.
• Good knowledge of Data warehousing, Bottom-Up and Top-Down Design methodologies, Operational Data Store (ODS), OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Analysis Services.
• Experience in Developing and Extending SSAS OLAP Cubes, Dimensions, KPIs and Report Action and Deploying and Processing SSAS objects.
• Knowledge in writing MDX for the Reports that uses OLAP Cubes.
• Strong experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints, Indexes and Batch Scripts using various DDL and DML commands.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Involved in huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/QA/UAT/Prod environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Offered support to developed products.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services across various environments.
• Involved in configuring SSRS Reports in SharePoint Integration mode.
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Created various SSRS reports involving variety of features like Reports, Maps, Charts, Sub-Reports, Linked Reports, Drill-Down, Drill-Through, Mutli-valued parameters.
• Leverages good database design understanding and capable to optimize development efforts in a distributed environment and also possesses a good understanding of programming languages, development tools.
• Good working knowledge of application development and analysis. Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Excellent analytical/communication skills, Team Play and very much result Oriented.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server BIDS

Languages: T-SQL,PL/SQL, C, C++, Java, C#, VB.Net

Operating Systems: Windows 2000/2003/XP/VISTA/WIN 7

Servers: Windows NT/ 2000/2003/2008/2012

Databases: MS-SQL Server 2012/2008R 2/ 2008/2005/2000 , MS-Access,Oracle 10g/11i,IBM DB2

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS) 2012/2008R 2/ 2008/2005/2000

Reporting Tools: SQL Server Reporting Services 2012/2008R2/2008/2005, Report Builder

OLAP Tools: SQL Server Analysis Services 2012/2008R2/2008/2005

Data Modeling Tools: Visio, Erwin

Scripting Language: PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. MS SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Converted complex Oracle PL/SQL packages, functions, procedures to SQL Server 2012(T-SQL).
• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Identified various data sources, formulated data dictionaries, designed and developed data models (physical/logical data models) based on the given specs and requirements. Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Created Tables, Views, Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on different database objects to obtain the required results.
• Create and maintain SQL Server queries, views, stored procedures, and SSIS packages which extend and support the SharePoint Global Support web application.
• Deployed the Packages and Scheduled them using SQL Server Agent Job.
• Experience in using SQL Profiler, Index Tuning Wizard and Performance Monitor to monitor SQL Server for dead locks and long running queries.
• Monitor strategies, processes, and procedures to ensure data integrity
• Filter and Sorting Data using Power View in Excel 2013. Developed Power Maps using Excel 2013 for Reporting.
• Worked closely with Project lead, architect and technical lead to estimate, understand the task and deliver the solution in a timely manner.
• Created Different Graphs and Charts for analyzing related Information using PowerBI Features. (PowerQuery, PowerPivot and PowerView).
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Generating scheduled report for business analysis or management decision using SQL server SSRS.
• Extensively used SSRS features such as Sorting, Interactive Sort, Groups, Filters and cascading parameters.

Environment: MSSQL Server 2012/2008/2005 , Visual Studio 2010/2005, Reporting Services (SSRS 2008/2005/2000 ),.NET 4.0/3.5, Business Intelligence Development Studio (BIDS), MS Office 2007, PowerPivot, UNIX, MS Access, TFS, ETL, MS Excel, Oracle sql developer.

Confidential, Tulsa, OK

MS SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created technical designs and user documentation.
• Converted complex Oracle PL/SQL packages, functions, procedures to SQL Server 2012(T-SQL).
• On a Regular basis created Store Procedures, Indexes, Views, User defined Functions, Constraints etc. on a daily basis for the reporting and query optimization.
• Configured, Installed and Administered Reporting Services 2012.
• Converted 100+ reports from Business Objects, Oracle Report Builder and Crystal Reports to SSRS 2012.
• Creating complex ad-hoc Reports, Sub Reports, Linked Reports, Drill through, and Drill down Reports.
• Integrated reports to the Application and designed custom Report Templates.
• Provided Ad-hoc queries and Reports for users to create their own reports.
• Involved in Dimensional modeling by identifying the fact and dimension tables and design star schemas for the SQL Server Analysis services.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Defined relationships between Measure groups and Dimensions.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Responsible for the analysis, design, development, testing and maintenance of ETL solutions.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and file files.
• Followed agile methodology and coordinated daily scrum meetings.

Environment: SQL Server 2012, Windows Server 2008R2, T-SQL, PL/SQL, SSIS, SSRS, SSAS, SAP Business Objects, Oracle Report Builder, Crystal Reports, Oracle

Confidential, Baltimore, MD

Sr. Data Analyst (ETL, Business Objects)

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytical reporting.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Involved in migration and conversion of Reports from Business Objects to SSRS 2008R2.
• Creating, Editing and Managing Report Models for Reporting Services.
• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Charts, Drill through and Drill down Reports.
• Experience in writing expressions in SSRS and expert in fine tuning the reports.
• Integrated SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS) 2010.
• Analyzedreportsand fixed bugs in stored procedures and data table.
• Designed & created OLAP Cubes with star schema using SSAS 2008 R2.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).
• Created and deployed analytics reports on to RoamBI.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Experience inError handlinganddebuggingcoding issues andtroubleshootproduction problems.
• Monitoring nightly ETL process from various highly disparate source systems. Sources included SQL based databases and XML Files.Also ensured that nightly backup jobs or cube processing or other ETL jobs didn’t interfere with each other. Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Monitoring the scheduled SSRS and Business Objects reports. Re-running the reports in case of any failures or data mismatches.
• Deploying reports and dashboards to SharePoint 2010.
• Managed security and user access Analysis Services cubes using creation of Groups and Roles by creating of windows AD and also Perspectives within the OLAP cube.
• Security and user access Administration in SharePoint BI center.
• Deploying the changes to QA, Staging and UAT Environment’s.
• Involved in Product Releases.

Environment: Informatica, SQL Server 2005/2008R2, Windows Server 2003/2008R2, T-SQL, SSIS, SSRS, SSAS, SAP Business Objects, Share Point 2010, BIDS, RoamBI, Reports Builder

Confidential, Chicago, IL

SQL DEVELOPER

Responsibilities:

• Use to get the user requirements from the Business Analyst.
• Designed different type of reports including: Tabular forms, Matrix form, List items, Charts and Linked reports.
• Designed reports using table filters, single value parameters, multi value parameters, and cascading parameters
• Scheduled reports using Standard and Data Driven Subscriptions.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types
• Written PowerShell script to generate SQL scripts to recreate the tables, stored procedures, views, triggers, key constraints, indexes, functions, jobs and more using SMO objects.
• Involved in creation of PowerShell script to run the SQL scripts to build a new Database.
• Used Toad Server for Comparison of Database Schemas.
• Written Dynamic queries and executed them through PowerShell.
• Written PowerShell script to Export the data from tables into CSV files.
• Written PowerShell script to Import the data into tables using OPENROWSET from CSV files.
• Written Dynamic SQL to update the date columns in the tables and run them through PowerShell.
• Involved in creation of PowerShell script to deploy SSRS reports to target server, using RS.exe.
• Created PowerShell script to deploy SSIS packages to target server, using SQLPSX.
• Created PowerShell script to deploy & process SSAS cubes to target server, using AMO objects.
• Added logging functionality, which makes sure that any important information shown on the console during execution, is also captured in a file for later analysis.
• Build .CMD files to which will be used to automate the process.
• Implemented XML files as configuration file.
• Written complex stored procedures and functions.

Environment: SQL Server 2008 (SSIS/SSRS/SSAS), Windows Server 2008, T-SQL, PowerShell, CSV files, Toad Server.

Confidential, Baton Rouge, LA

Data Analyst

Responsibilities:

• Created and designed data reports to help the business in making decisions.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Experience in mapping and tracing data from system to system.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Involved in Dimensional modeling by identifying the fact and dimension tables and design start flake schemas for the SQL Server Analysis services
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i.

Confidential

SQL Server Developer

Responsibilities:

• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Involved in performing data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Defined Check constraints, Business Rules, Indexes and Views.
• Worked with Configurations on the Server for sending automatic e-mails to the respective people when a DTS process failure or success.
• Developed DTS Packages, worked with DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Performed Data migration (import & export - BCP) from Text to SQL Server.
• Performed development support, document reviews, test plan, integration of the system.
• Developed database objects such as DTS Packages, Procedures, Functions, Tables, Triggers, and indexes using T-SQL/PL SQL, SQL Analyzer and Enterprise Manager.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: SQL Server 2000, ASP, ADO, Java Script, and Microsoft Visual Studio 6.0., Visio, IIS.