SUMMARY

• A Microsoft Business Intelligence Professional with experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008 R2/2012.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
• Experience in Logical & Physical Data modeling, data architecture designs.
• Experience in Normalization and De-Normalization Processes.
• Experience in writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server - Stored Procedures, Triggers, User-defined Functions and Views, Cursors, Performance tuning of Stored Procedures and T-SQL Queries.
• Good exposure working on C#, VB.NET framework.
• Experience in ETL from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, and BULK INSERT also knowledge on other tools like Data stage.
• Experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling and Custom Logging for SSIS Packages.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Good Knowledge on Microstrategy reports, Development of Metrics, Attributes, Filters and various other Microstrategy components.
• 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.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, datasource views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multidimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities.
• Wrote MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports.
• Created Scoreboard/Dashboard pages in Performance point server (PPS) and worked in various environments with Distributed Applications.
• Experience in using proClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps.
• Worked In Agile Fixed Price contracts more than once.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2008/2010/2012/2014, MS Access 2003/2005/2008/2010

Languages: SQL, MDX, C, ASP.NET, C#(.NET)

Web Technologies: HTML

Tools: and Packages: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SSIS, SSRS, SSAS, Visual Studio .NET, Team Foundation Server (TFS), ERWIN 7.3/7.2.

Operating Systems: Windows Vista/XP/ 2000/2003/2007/2008, MAC, MS-DOS

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS),Microstrategy, Informatica, Data Stage.

Application Packages: MS Office, VBA, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

MSBI Developer

Responsibilities:

• Worked on design and development of a new data warehouse and created new data models using MS Visio.
• Responsible for maintaining data warehouse, ETL Jobs, creating new database objects and SSIS Packages in a SQL Server 2008 R2 Environment and also simultaneously working on SQL Server Upgrade to 2014.
• Worked on the performance tuning of the existing data warehouse and modified the procedures and tables to enhance the performance of the data warehouse.
• Used SQL Server Data Tools for schema and comparison between two databases in two different environments.
• Created new ETL Jobs to bring in data from different core systems depending on the business requirements received.
• Designed and developed a new data warehouse for the company based on the concept of star schema and tested it by inserting test data that has been generated by Red gate.
• Created ETL process using SSIS to load the actual data from different core systems to the tested data warehouse.
• Modified the existing ETL Processes by altering the SSIS packages and enhanced their performance by altering the blocking transformations and sometimes replacing the blocking transformation with non-blocking transformations.
• Also enhanced the performance of the SSIS packages by partitioning the extremely large tables and also by dropping clustered indexes on huge tables and while in the pre- execution phase and recreating them in the post execution phase.
• Worked on decommissioning of legacy server and documented the process.
• Worked on re-engineering some ETL processes to accommodate the new acquisitions by the company.
• Worked on existing complex SQL Codes to fix the errors and change the procedures to match the requirements for various business reasons.
• Works on development and enhancement of SSAS cubes which are the data sources for the front end reporting tool.
• Wrote scripts using MDX Queries like for Addition of new calculations in reports and dashboards.
• Created static reports using MDX queries and creating MDX base report definition and also wrote MDX queries to extract data from data marts.
• Worked on the integration of SSRS to share point there by increasing the SSRS reporting accessibility to wider range of users.
• Creates complex reports for high level executives that are used for performance analysis and strategic planning of their respective departments.
• Performed the migration of procedures, tables with and without data and other database objects between different environments.
• Performed database backups and restores periodically along with refreshing various environments.
• Maintained the database and also the security and logins of the SQL Server.
• Converted Hundreds of reports from COGNOS to SSRS and worked on server decommissioning, saving the costs of multiple reporting tool licenses to the company and the hassle of maintaining extra servers.
• Also created new COGNOS Reports for various business requirements.
• Converted MS Access Databases to SQL Server and created new ETL’s to automate the daily data load there by increasing the data accuracy and usage by more than 60% (Converted around 11 MS Access Databases).
• Organized training sessions to employees from various departments of the company on building reports there by making them self-sufficient and independent.
• Organized meetings with business users to gather requirements there by reducing the requirement gathering and processing time exponentially.

Environment: MS SQL Server 2008R2, MS SQL Server 2014,BIDS SSIS,SSRS,SSAS, Visual Studio 2010, Visual Studio 2008, COGNOS, MS Excel, MS Access and Window 2008 R2, MS Visio.

Confidential, Houston, TX

MSBI/ETL Developer

Responsibilities:

• Installation and configuration of SQL Server 2012.
• Took over the designing of newer data warehouse and produced data models using Erwin. Considered different ways of approaching the designing of database and documented all the possible ways before building the data warehouse.
• Discussed and documented the building of data warehouse at every step.
• Exported the existing data from a legacy database to a newer database.
• Optimized the existing stored procedures and automated them for various tasks.
• Created new Database objects like Tables, Views, indexes and functions.
• Developed a new set of complex stored procedures for newer business requirements.
• Imported data from various sources like Excel, Access.
• Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
• Participated in disaster prevention and recovery strategies.
• Optimized the existing SSIS packages to fix various issues and improve performance.
• Built SSIS Packages for processing fact and dimension tables with complex transforms.
• Designed new SSIS packages to extract data from newer OLAP and OLTP sources and transferred the data to SQL Server using BIDS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Worked on troubleshooting various issues with the existing ETL process.
• Provided documentation for SSIS packages and also various other procedures.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery
• Worked on Microstrategy for producing various reports.
• Built new attributes, metrics and filters.
• Altered the existing attributes and metrics according to the changes at the data warehouse level.
• Assisted on building various complex reports at Microstrategy level.

Environment: MS SQL Server 2012, BIDS SSIS, Visual Studio 2010, Microstrategy, MS Excel, MS Access and Window 2008 R2, Erwin.

Confidential, San Diego, CA

MSBI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008(R2).
• Analyzed the business requirements and building logical and physical data models.
• Developed new stored procedures and optimize existing ones.
• Developed template scripts for users so they can generate their own daily/weekly/monthly reports.
• Developed and implemented stored procedures and triggers for automation tasks.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
• Modify the existing SSIS packages to reflect the new business requirements.
• Developed packages to create Error Fallout Reports, send Business and IT mails.
• Created connection strings using various external drivers like Relativity Drivers or CONNX Drivers.
• Apply various transformations like Slowly Changing Dimension (SCD), Multicasting, Union, Derived Column and Data Conversion.
• Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
• Used various advanced SSIS functionalities like complex joins, conditional splitting for better performance during package execution.
• Developed Unit test plans for SSIS packages.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Set up traces and use profiler to troubleshoot performance issues.
• Created drill-down, drill-through and sub reports using SQL Server Reporting Services 2008R2.
• Developed different chart reports for customers, based on the requirements.
• Deploy the reports to the report manager and maintain the same providing necessary access to the users.
• Created roles for the reports and assign them accordingly.
• Developed UI mockups and ER diagrams using Visio and assisted teams working on Citrix and VMware.
• Used JIRA for bug/issue tracking and project management, which supports SVN.
• Created reports based on the business requirements using COGNOS.

Environment: MS SQL Server 2008(R2), BIDS SSIS, SSRS, JIRA, COGNOS, MS Visio 2010/2007, Source Safe, Visual Studio 2010, C#.Net 2008 and Window 7.Windows Server 2008 R2,ERWIN.

Confidential, San Antonio, TX

Sr.SQL Server BI Developer

Responsibilities:

• Gather business requirements from the users and develop one pager.
• Worked on full development cycle of data warehouse including requirement gathering, design, implementation and maintenance.
• Developed business and functional documents.
• Developed database objects like tables, functions, views and stored procedures.
• Load data from flat files to SQL Server using BCP.
• Created SSIS packages to import the data into SQL Server 2012.
• Worked on SSIS Script component using Visual Basic Applications and C#, by creating generic C# components that can be used in the external packages in SSIS.
• Worked with the team responsible for data modeling and the development of the applications with ASP.NET and SQL Server Database and also extensively involved in developing business and data layers components that are shared across the project platform and also assisted them in extracting data from a Teradata database.
• Created reports and dashboards to retrieve data using stored procedures that accepts parameters.
• Developed Excel reports (Regular, PowerPivot and Power View).
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Implemented report subscription which sends out reports daily to the different users.
• Tracking report usage by logging the information such as the number of times the reports has been viewed and user related information.
• Store user specific parameters for the reports there by helping customers to reduce the number of selections that need to be made every time.
• Automate SSRS data audit reports and source - destination reports.
• Used UNIX shell scripting for various batch processing and data migration.
• Developed reports from Cubes and automate them.
• Involved in the creation of cubes in the MS SQL Analysis Services.
• Provide documentation for all kinds of reports and SSIS packages.
• Assisted in XML coding in order to create front end screen insert activities.
• Involved in suggesting automated processes to save resources and reduce human errors.

Environment: MS SQL Server 2008/2005, BIDS(SSRS,SSAS,SSIS), T-SQL, MS Visio 2007/2003, TFS, Windows 2003/2000 Advanced Server, Unix, Visual Studio 2010, Erwin 7.3, C#.Net 2005.

Confidential, LA,CA

Senior BI/SQL Developer (SQL/SSIS/SSAS/SSRS)

Responsibilities:

• Dynamically supported business users for given requirements and developed the reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc). And then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Migration of Crystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, ProClarity, Team Foundation Server (TFS) Oracle 10g/9i, VBScript.

Confidential, Findlay OH

SQL BI Developer

Responsibilities:

• Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
• Createdpartition tablefor very large database for good performance.
• Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Wrote SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS.
• DeployedSSISpackages and Reports to Production Servers.
• Involved in creation of Data warehouse Cubes inSQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool inSSIS.
• Maintained system monitoring jobs and providehigh availability support.
• Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
• ParticipatedDatabases Architectureanddata modelingdesign.
• Performing DBA functions, installing, configuring and supporting database systems and also performed disaster recovery of various databases.
• Also assisted in keeping up with the backup schedules and providing production support at various points of time by troubleshooting various technical issues.
• Reported all events and requirements through established reporting mechanisms inSSRS.
• Reviewed and developeddata models and database designswith development teams.
• Wrotestore proceduresfor some job automations.
• Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL ServerAnalysis Services.
• Designed and developedMS SQL ServerReporting Services (SSRS)under SQL Server 2005.

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity,C#,ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential

SQL Programmer

Responsibilities:

• Performed the Creation, manipulation and supporting the SQL Server databases.
• Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
• Created stored procedures and triggers which were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Wrote triggers, stored procedures and manipulated the data using DDL and DML functions.
• Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS).
• Written complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of TSQL queries.
• According to the business requirements made the documentation of the performed tasks.
• Extensively 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.
• Worked on various scripting languages like JavaScript and CSS.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.