SUMMARY

• Over 8 years of IT experience in Database Design, Development, Implementation and Support using various Confidential technologies(SQL Server 2005/2008/2012 , T - SQL) in both OLTP and data warehousing environments
• Expertise in SQL Server and T-SQL(DDL, DML and DCL) in constructing Tables, Joins, Indexed views, Indexes, Complex Stored procedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules
• Strong technical knowledge in SQL Server BI suite (ETL, Reporting, Analytics, Dashboards) using DTS/SIS, SSAS, SSRS and various 3rd party tools
• Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin and other Data modeling tools
• Expert in creating, debugging, configuring and deploying ETL packages designed in Data Transformation Services (DTS) and MS SQL Server Integration Services (SSIS)
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert and BCP)
• Hands on experience in designing Enterprise and Adcock reports using MS SQL Server Reporting Services (SSRS)
• Experience in configuration of report server and report manager for job scheduling, giving permissions to different level of users in SQL Server Reporting Services (SSRS)
• Experience in creating OLAP Data marts using SQL Server Analysis Server (SSAS)
• Experience in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions.
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005) using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions
• Experience deploying database objects (T-SQL scripts, stored procedures, SSIS, SSRS, and SSAS) from Development server to QA and Production
• Hands on experience in Package Migration from DTS Packages to Integration Services.
• Basic exposure on creating score cards and dashboards using MS Office Performance Point Server 2007(MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services
• Experience in Monitoring and Tuning SQL Server Performance
• Responsible for creating Requirements Documentation for various projects
• Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease

TECHNICAL SKILLS

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

Operating Systems: - WINDOWS 7, 8

Databases: - MS SQL Server 2005, 2008, 2012, Oracle 11g, Teradata

Reporting Tools: - MS SSRS 2008, Report Builder, Crystal Reports

ETL Tools: - MS SSIS 2008, 2010

Other Tools: - Alteryx

GUI: - Visual Studio 2010, BIDS, SQL Server Data Tools

Web Languages & Scripting: -JavaScript, VBScript, HTML, CSS, XML SQL Server Programming 2005/ 2008, 2012, 2014

Diagramming Tool: -MS Visio

Methodology: -Agile, Kimball

Application: - Dynamics CRM 2011, SharePoint 2013

Miscellaneous: - MS Office Suite, Photoshop, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

SQL BI Analyst (T.SQL, Teradata)

Responsibilities:

• Translated business requirements to technical definitions to help develop a solution for mapping scenarios.
• Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailedmap strategy
• Worked independently in troubleshooting the issues, data mining, data analysis and provide estimates for planned activities
• Worked in migration project to migrate customers from legacy rate plans to new rate plans using Alteryx tool
• Scheduled Alteryx modules and monitored the out coming data results
• Provided various mapping solutions based on the business need, troubleshoot the reasons for unmapped customers
• UsedTeradata utilities fastload to load data
• Wrote views based on business reporting requirements, performance tuning and various complex SQL queries optimization
• Extensively usedSQL Analyzerand wrotecomplex SQL Queriesusing joins, sub queries and correlated sub queries
• Created New SSRS Reports and did Adhoc changes/Fixes to the Existing Reports.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the Dev. Team if any stale data or ETL failed.
• Developed Power BI reports using Power Query from SharePoint & different Data sources.
• Monitor, Triage, Track and resolve issues with the Excel Power BI reports.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks
• Created Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed Event Types
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler, and third party tools
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters
• Created a process doc for all the tasks handled

Environment: Teradata SQL Assistant, SQL Server Management Studio 2008R2, Confidential Visual Studio 2008, SSRS, SSIS, Alteryx Designer 9.1, Teradata Fastload, Teradata FastExport

Confidential, Redmond, WA

SQL BI Developer (T.SQL, SSIS, SSRS, CRM)

Responsibilities:

• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings
• Involved in writing heavy T-SQL stored procedures, complex joins, new SQL2008 T-SQL features like Merge, Except commands
• Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
• Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Designed & developed ETL procedures, data validations and data migrations.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task FailedEvent Types.
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files,COSMOSetc. toSQLServer using SSIS using various features like ‘’mkdata conversion
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• 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-2008.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Deployed reports across Test, Developmentand Production Environments.
• Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level.
• Responsible for admin related tasks like adding users, backup and restore database, adding linked servers, Job scheduling, configured SQL server maintenance plans grant database access roles to the other users.
• Involved in Trouble Shooting Complex Reports.
• Involved in code reviews, change control and auditing procedures.
• Created various views and dashboards in Dynamics CRM
• Created and maintained custom SSRS reports for CRM
• Provided general production support for CRM related tickets
• Handled ad hock data requests for CRM
• Did some data massaging on bad data from a private site and bulk uploaded to CRM
• Handled various ticket requests
• Responsible for providing detail analysis report on survey data from survey responses and various survey reports using excel Macros
• Knowledge inCOSMOSand Scope Script to pull data fromCOSMOS
• Worked as point of contact for localized Content update on live site
• Extensively used SharePoint for maintaining internal ticket queue, various documentation, as a dashboard for reports
• Served as a backup resource in team and handled their responsibilities equally in their absence

Environment: SQL Server Management Studio 2008R2/2012, Confidential Visual Studio, MS BIDS, SQL Server Data Tools, SSRS, SSIS, SSAS, Active Directory, .NET 2.0/3.5 Framework, MS Visio, Dynamics

Confidential, Norcross, GA

BI Developer (SSIS.SSRS.T-SQL)

Responsibilities:

• Analyzed Business requirement for reporting purpose.
• 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.
• Developed Stored Procedures to support ETLs and Reporting.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions
• Experience with Oracle-PL/SQL programming in one of the source systems
• 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 2008. 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-2008.
• 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 2008 as assigned.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) 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.

Confidential, Houston, TX

BI Developer

Responsibilities:

• Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs
• Point of contact for all Data processes, Data Mappings, Data dictionaries, Data pulls
• & reporting solutions.
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users and also for reinsurers and producers.
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Creating custom forms using MS Access to facilitate user data requests on demand.
• Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage
• Developing training materials and underwritings
• Supported classic ASP and Visual basic application
• Involved in User communication for requirement gathering and Change control and code control policies and procedures

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008/2005, SQL Server Analysis Services (SSAS) 2005, Share Point, MS Project, MS Access 2003/2007, VB, Classic ASP

Confidential, Blueash, OH

Data and Report Developer

Responsibilities:

• Main point of contact for market data and data analysis.
• Extracting market data using D & B Market Insight to CSV files, transforming the data to the desired format and then loading the data into local company databases using SSIS.
• Assisting with data cleansing and preparation to facilitate enhancement of existing databases and tools for analysis and decision making.
• Defined OLAP cubes based on fact tables and dimension tables to suit a range of report/analysis requirements with SQL Server 2005 Analysis Services (SSAS).
• Worked with installation, configuration and deployment of SQL Server Reporting Services (SSRS).
• Creating various reports using SSRS for multiple sales teams within the company to support sales/builds.
• Creating custom Confidential Access Forms with code behind in Visual Basic for Applications (VBA) for users to query and pull the data and integrating multiple in-house tools on to those Forms to increase the productivity and performance.
• Creating prospect customers campaign lists for marketing teams using UNICA Campaign Management tool.
• Plotting customer data on a map and performing various operations like Distance Calculation to the nearest Coaxial Cable/Fiber Cable, Extraction of customers within particular zip code/area or within specified distance of the Coax/Fiber cable, etc. using MapInfo.

Environment: MS SQL Server 2005, SQL Server Reporting Services (SSRS) 2005, SQL Server Integration Services (SSIS) 2005, SQL Server Analysis Services (SSAS) 2005, MS Access 2003, VBA

Confidential, Cleveland, Ohio

SQL Server Developer

Responsibilities:

• Involved in writing views, complex stored procedures and triggers.
• Scheduled the ETL Process using Jobs.
• Modified SSIS packages to accomplish critical business logic.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Scheduled reports for the end users and Customers to view.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Fixed issues in the existing reports.
• Responsible for maintaining the accuracy and quality of the data.

Environment: SQL Server 2005, SQL Server Reporting Services 2005 (SSRS), SQL Server Integration Services 2005(SSIS), SQL Server Analysis Services (SSAS) 2005, T-SQL, MS Access

Confidential

BI Consultant

Responsibilities:

• Involved in requirements gathering sessions with the users and Business Analysts to understand business analysis functions to be supported.
• Developed reports of the data, and worked with business users to refine their analysis requirements.
• Involved in package migration from DTS packages to Integration services.
• Developed ETL packages using SSIS and stored procedurefor data loading.
• Extensively used T-SQL statements to write complex queries.
• Extensively used Stored Procedures. Wrote new stored procedures and modified existing ones andtuned them such that they perform well.
• Used Indexes to enhance the performance of individual queries and enhanced the stored procedure.
• Dropped and recreated the Indexes on tables for performance improvements.
• Customized and developed reports using Confidential SQL Reporting Services (SSRS).
• Customized usage based optimization, data compression and storage optimization, query tuning.
• Developed roles, policies and procedures for ensuring the security and integrity of the report.
• Written technical design documentation for alterations to current business logic and future project designs.

Environment: SQL Server 2005, SQL Server Reporting Services 2005 (SSRS), SQL Server Integration Services 2005(SSIS), T-SQL, SQL Server Profiler, MS Access, Excel.