SUMMARY

• 8+ years of IT experience in Data Design, Development, Integration and Implementation on Microsoft SQL Server SQL Server 2000/2005/2008/2008 R2/2012/2014, Confidential - SQL.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Experience in handling the offshore/onsite teams.
• Extensive experience with Confidential -SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Experience in Creation of Master Data Services for Master Data Management.
• Experience on Data Quality services for data cleansing.
• Good Understanding in all the Latest BI Tools Tableau, Qlikview and Dashboard Design.
• Strong Knowledge on database and data warehousing concepts (OLTP & OLAP).
• Strong Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and BCP).
• Good Exposure on Control flow level items, Data flow Transformations and Event Handlers.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2014/2 /2000/7/6.5.
• Great ability to create and manage various database objects like tables, views.
• Excellent Confidential -SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experience in Up gradation of SQL Server 2000 databases to SQL Server 2005/2008/2012/2014 applying Service Packs and Hot fixes.
• Experienced in using ETL tools in (SSIS) MS SQL 2014, MS SQL 2012, MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Teradata and Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience in Deploying the SSIS Packages from development server to production server
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in modifying MDX Cubes and Dimensions in SSAS.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Good knowledge in various reporting Tools like IBM Cognos v10 and BO.
• Expertise in designing reports related to Web intelligence, Desktop intelligence
• Played a prominent role in designing the Universes, Cross functional in nature
• Exposure to Business Objects Import Wizard tool and publishing wizard tools.
• Hands on experience towards Migration scenarios, scheduling and publishing the reports
• Hands on experience towards Report Conversion techniques.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Played a significant role of QA testing Confidential various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Good team player and self-starter with excellent communication skills to work independently or as a part of team in Telecom, Financial, Retail & Healthcare industries.
• Expertise in defining the business process flow and gathering business requirements
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, SQL Server 2014, SQL Server 2012,SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, SSAS, Performance Point Server 2010.

Database: MS SQL Server 2014, 2012, 2008, 2005, 2000, Oracle 9i/11g.

Language: C, C++, Confidential -SQL, Dynamic SQL,PL/SQL, ASP.NET, Visual Basic, Core Java, Unix, Perl, Shell.

Operating System: Windows Vista/XP/2003/2000, NT & Windows 9x, Windows 7, MS-DOS and UNIX.

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),SSDT, Power Pivot, Microsoft Office (MS),Excel Power Pivot, Excel Data Explorer, Tableau, Qlick View, IBM Cognos v10, BO,TFS.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP, OLE-DB, XML, ASP, HTML, FTP.

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, 2010.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Lead MS SQL Server/BI Developer

Responsibilities:

• The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data.
• Created SSIS Packages to integrate data coming from Oracle, Teradata databases, Text files and Excel files.
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
• Developed different varieties of Scorecards, Dashboards & analytical charts using PPS 2010.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Integrating the PPS 2010 Reports into the SharePoint 2010 as part of a web site.
• Created SQL server reports using 2008/2012 for manager, customer support and that can deliver Confidential client’s station
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute SQL flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS)
• Created OLAP cubes in SQL Server Analysis Services 2014/2012/2008 for company wide use. The data being compared in the cubes had never been available together in the same application previously.
• Created SSIS packages using different transformations in SSIS toolbox like aggregate, merge, merge join, pivot etc
• Supported in creating KPI, calculation members and measure groups, and MDX queries
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart and OLAP cubes using SSAS
• Defined Relationships Between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, Dimension Granularity within a Measure Group in SSAS
• Experience on SSAS Tabular Model and SSAS Cube Model and support the existing database components
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2014/2012/2008 .
• Deploying SSIS packages to production systems using Deployment manifest files.
• Scheduled the ETL Package Using SQL Server 2014/2012/2008 R2 Management Studio.
• Responsible for unit testing, Peer testing and Integration testing of data warehouse jobs.
• Prepared Unit Test Cases as per our business logic.

Environment: SQL Server 2014/2012/2008 R2, Confidential -SQL,PL/SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Performance Point Server 2010, Tableau,C#,.net.

Confidential, Seattle, WA

Sr MS SQL Server/BI Developer

Responsibilities:

• Understanding the business requirements and designing applications to meet customer needs.
• Developed and maintained technical documentation from source to target load process and ETL development process.
• Involved in creating and designing packages using SSIS by using the existing tasks and transformations.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Extensively worked in data Extraction, Transformation and Loading from source to target system.
• Implemented Event Handlers and Error Handling in SSIS packages
• Scheduled the ETL Package using SQL Server 2012/2008 R2 Management Studio.
• Experienced in writing complexSQLQueries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modeling using ERWIN data modeler
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub
• Reports using SQL Server Reporting Services 2012/2008.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary Reports by using SSRS
• Created new cubes and modified existing cubes using SSAS 2012/2008 to make data available for the decision makers
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports by using cogonos tool for business users.
• Good understanding on Structuring Metadata and Cognos Models using Framework Manager.
• Responsible for code migration across environments (DEV, UAT, Prod).
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Build efficient SSIS packages for processing fact and dimension tables with complex
• Transforms and type 1 and type 2 slowly changing dimensions.
• Integrated SQL Server 2008 reporting services with Microsoft Office Share point Server
• To automatically deliver reports to the Share Point portal
• Created mapping tables to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special
• Log tables with high level SSIS package execution results
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
• Worked with MDX to query cube’s data.
• Used data profiling task in SSIS 2012/2008 to identify poor data and repair it.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
• Created report snapshots to improve the performance of SSRS.
• Improved the accuracy of the source data by implementing data validation on the source data for reporting
• Used MDX to define KPI’s, calculated members in the cubes.
• Created partitions of the Analysis Services cube to improve performance.
• Designed reports and tuned them for optimal performance when using multiple parameters
• Used Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2005/2008, Confidential -SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler, MS Excel 2003, Visual Studio, C#, ASP.Net, Visual Team Foundation Server, Visual Source Safe. MS Visio, Cognos 8.2.

Confidential, Los Angeles, CA

MS SQL Server/BI Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using Confidential -SQL in Development and Production environment for SQL Server 2008.
• Involving in designing, testing for SSIS Packages to load bulk data into database.
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Developer and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in Developing and Publishing Reports in SQL Server 2008 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2008 from the requirement document.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
• Involving in deploying and scheduling SSIS packages.
• Creating Table, matrix, drill- down and drill - through reports and Charts using SSRS.
• Creation of tabular, drilldown and drill through reports.
• As per Client Requirements, creation of tabular, drill down and drill through reports.
• Involving in deploying Reports.
• Rendering the Reports in the form of PDF, EXCEL and CSV to the Clients.
• Implementing subscriptions, caching and securities for reports.

Environment: s: SQL Server 2008, Confidential -SQL,PL/SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, Confidential -SQL,MDX,, BO, C#, .net.

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Analyze the source map documents and creating packages to move the data from source to destination.
• Understanding the Business and its Requirements.
• Creating packages for implementing ETL by using various control flow items for each loop, for loop and data Flow transformations execute SQL, conditional split, multicast, derived column, lookup, sort, union all etc. Did error handling while moving the data.
• Implemented Performance Tuning Confidential various levels.
• Implemented check point configuration, package configuration in packages for better reusability.
• Analyze the specified documents, based on that created cubes, measure groups from the data sources.
• Process the facts dimensions and implemented aggregation on granularity basis.
• Design and development of database scripts and procedures
• Develop the package for ETL process (First Run and Incremental)
• Involved in creation of the package and was responsible for moving the package from development server to production server.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQLServer2005, 2008Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage configuration files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry,performingdatabase capacity planning.
• Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team when issues rose in the packages.
• Creating Table, matrix, drill- down and drill - through reports and Charts using SSRS.
• Involving in deploying Reports.

Environment: SQL Server 20 (2003, 64 bit edition of SQL server 2000), DTS, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, c#, .Net.

Confidential

BI Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins.
• Involved in mentoring the developers to follow the guidelines of performance optimization
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Involved in making mappings and transformations using DTS Transform Data Task, Data driven query task
• Creating and Modifying Confidential -SQL stored procedures/triggers for validating the integrity of
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Defined attribute properties in a Parent Child Dimensions.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Defined specific read/process permissions for the users in SSAS instance.
• Implemented user based security in SSRS reports to limit the access of reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Created SSIS packages to move data from oracle to SQL Server which involved using
• Various transformations, developing SQL queries
• Designed and deployed monthly sales reports for the business users using SSRS.
• Involved in project planning sessions with project managers, business analysts, and team members to analyze business.
• Involved in Universe developments.
• Used report level filters, URL reporting using parameters passed by hyper links and report variables.

Environment: Windows XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ASP.NET, Confidential -SQL, MS Visual Studio 2005, BO XI R2 and Crystal Reports, c#, .Net.