SUMMARY

• A SQL BI Developer wif 5+ yrs. of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2012/2014.
• 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 principals.
• 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.
• 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
• Experienced in whole cycle of DTS/SQL server integration services (SSIS 2014) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• 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.
• Expert in designing Confidential reports using SQL Server Reporting Services (SSRS 2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2012.
• 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.
• Good Knowledge on Microstrategy reports, Development of Metrics, Attributes, Filters and various other Microstrategy components.
• 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, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional 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 dat 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 wif Distributed Applications.
• Experience in using proClarity tool to analyze teh data in teh cube by using different features like Chart view, Decomposition Tree, Performance Maps.
• Worked In Agile Fixed Price contracts more TEMPthan once.
• Good team player, strong interpersonal and communication skills combined wif self-motivation, initiative and teh ability to think outside teh box.

TECHNICAL SKILLS

RDBMS: MS SQL Server 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

SQL Developer

Responsibilities

• Created Entity Relationship (ER) Diagrams to teh proposed database
• Created database objects such as tables,views, stored procedures, Triggers etc.
• Maintain referential integrity, domain integrity and column integrity by using teh available options such as constraints etc.
• Experience inSSIS, SSASandSSRSof MS SQL Server tools.
• Createdtabularandmatrix reportsinSSRS. Wrote stored procedures and functions to create SSRS reports.
• Involved in thecreation and deploymentof teh reports usingSSRSand configuring teh SQL Server Reporting Server
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Involved in designing cubes inSSASenvironment using Snowflake and Star Schemas.
• Identify columns for Primary Keys in all teh tables at teh design time and create them.
• Created functions to provide custom functionality as per teh requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Endure dat teh code is written keeping in mind any security issues such as SQL Injection.
• Developing reports in SQL Server Reporting Services.
• Developing SSRS Reports
• Designed, Developed and Deployed SSIS Packages.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Participated in discussions involving teh application creation and understand teh requirements and provide teh back-end functionality for teh applications.
• Participate in development and creation of Data warehouses.
• Created cubes in SQL Server Analysis Services.

Environment: MSSQL Server 2008 Confidential Edition, T-SQL, ODBC, ER/Studio, SSAS, SSIS Packages, SSRS, SQL profiler

Confidential, VA

SQL Developer

Responsibilities:

• Installation and configuration of SQL Server 2014.
• Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
• Exported teh existing data from a legacy database to a newer database.
• Optimized teh 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 teh slow running queries and teh server activity.
• Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS transformations.
• Optimized teh existing SSIS packages to fix various issues and improve performance.
• Designed new SSIS packages to extract data from newer OLAP and OLTP sources and transferred teh 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 wif teh existing ETL process.
• Provided documentation for SSIS packages.
• Performed teh deployment of teh developed Packages into various Environments.
• Involved in setting up SQL Server Agent Jobs for periodic Backups wif backup devices, database maintenance plans and recovery
• Worked on Microstrategy for producing various reports.
• Built new attributes, metrics and filters.
• Altered teh existing attributes and metrics according to teh changes at teh data warehouse level.
• Assisted on building various complex reports at Microstrategy level.

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

Confidential, Maryland

SQL Developer

Responsibilities:

• Installation and configuration of SQL Server 2014.
• Analyzed teh 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 teh same as jobs using SQL Server Agent.
• Modify teh existing SSIS packages to reflect teh 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.
• 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 teh requirements.
• Deploy teh reports to teh report manager and maintain teh same providing necessary access to teh users.
• Created roles for teh 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.

Environment: MS SQL Server 2014, BIDS SSIS, SSRS, JIRA, MS Visio 2010, Source Safe, Visual Studio 2010, C#.Net 2008 and Window 7.Windows Server 2008 R2.

Confidential, Minneapolis, MN

Sr. SQL Server BI Developer

Responsibilities:

• Gather business requirements from teh users and develop one pager.
• 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 teh data into SQL Server 2014.
• Worked on SSIS Script component using Visual Basic Applications and C#, by creating generic C# components dat can be used in teh external packages in SSIS.
• Worked wif teh team responsible for data modeling and teh development of teh applications wif ASP.NET and SQL Server Database and also extensively involved in developing business and data layers components dat are shared across teh project platform and also assisted them in extracting data from a Teradata database.
• Created reports and dashboards to retrieve data using stored procedures dat accepts parameters.
• Developed Excel reports (Regular, PowerPivot and Power View).
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2014.
• Implemented report subscription which sends out reports daily to teh different users.
• Tracking report usage by logging teh information such as teh number of times teh reports TEMPhas been viewed and user related information.
• Store user specific parameters for teh reports their by helping customers to reduce teh number of selections dat need to be made every time.
• Automate SSRS data audit reports and source - destination reports.
• Developed reports from Cubes and automate them.
• Involved in teh creation of cubes in teh 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 2014, BIDS(SSRS,SSAS,SSIS), T-SQL, MS Visio 2014, TFS, Windows 2003/2000 Advanced Server, Unix, Visual Studio 2010, ERwin 7.3, C#.Net 2005.

Confidential, San Antonio, TX

Senior BI/SQL Developer

Responsibilities:

• Dynamically supported business users for given requirements and developed teh 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 teh requirement.
• Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc). And then loaded teh data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed teh packages wif monitoring features and logging so dat audit information of teh packages and their execution results are loaded in to teh audit table.
• Created database maintenance planner for teh 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 wif teh cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing teh cube to get teh latest information updated and deployment of Cubes to teh production server.
• Generated various reports wif drilldowns, calculated members, dropdowns from teh cubes by connecting to Analysis server from SSRS.
• Worked on large data warehouse Analysis services servers and developed teh different reports for teh analysis from dat servers.
• Extensively involved in teh SSAS storage and partitions, and aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Created data sources, connection strings and defined teh datasets for generating teh report.
• Designed and written teh queries in teh query builder for retrieving teh data.
• Created and worked wif drill down reports and identified teh report parameters.
• Used various report items like tables, sub report and charts to develop teh reports in SSRS.
• Deployed and generated reports on to teh server using teh Reporting Services Report Manager.
• Worked wif 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.
• Migrated Crystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2014, 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.