SUMMARY:

• Around 8+ years of experience in data modeling, data design, database programming of SQL Server 2005/2008/2012 for OLTP/OLAP/ETL environments.
• Extensively worked on Dimensional Modelling, Data Modelling, Normalization and De - Normalization techniques for both OLTP and OLAP.
• Highly experienced wif SQL Server Integration Services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Proficient in creating highly analytical & detailed reports from ERP system for various departments like sales, accounting, inventory, financial, customer service, marketing, datawarehouse, and human resource by using SQL Server Reporting Service/SQL Server Analysis Service (OLAP).
• Experienced on writing SQL, T-SQL, stored procedures, triggers, and functions in MS SQL Server 2008/2012
• Very good noledge in designing database objects like Tables, Views, Constraints, Indexes and defaults.
• Implemented Experian, Trillium tools for data cleansing.
• Implemented SQL Server Indexing, Index tuning using Index Tuning Wizard and Tuning Advisor
• Excellent noledge in performance tuning and query optimization Using SQL Profiler, Execution Plan, Performance Monitor.
• Migrated and Upgraded DTS Packages to SSIS Packages across all environments.
• Experience in creating DTS/SSIS packages wif ActiveX scripting for transferred data modifications.
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS).
• Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.
• Experience in gathering business requirements and translating them into technical specification and creating reports wif respect to business requirement
• Hands-on-experience on Reporting Architecture components and various tools of SQL Server Reporting Services(2005/2008)
• Solid design and development experience in Developing various kind of reports (cascading parameters, pick lists, drill down and drill through)
• Created Adhoc reports and data driven subscription reports by using Report Builder in SSRS
• Expertise in Troubleshooting, Installation, Configuration and Deployment of Reporting services using SSRS (2005/2008).
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Solid Knowledge in Developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc and created various user roles.
• Proficient in designing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• End to end experience in designing and deploying data visualizations using Tableau
• Created adhoc reports to users in Web Intelligence Rich Client by connecting various data sources like SQL, Excel, Salesforce, and SSAS Cubes.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica
• Developed Informatica Workflows and sessions associated wif the mappings using Workflow Manager

TECHNICAL SKILLS:

Operating Systems: Windows 2003/2008 Advanced Server, NT & Windows 9x, LinuxOS, UNIX.

Tools: SSIS, SSAS, SSRS, Jira, BMC Remedy

RDBMS: MS SQL Server 2000/2005/2008, MS Access, Oracle 8i & 9i, MYSQL.

Languages: T-SQL, MDX, PL/SQL, C, Visual Basic 6.0, VB Script, VB .NET, ASP .NET

Database Utilities: Enterprise Manager, Query Analyzer, SSMS, SQLProfiler, DTS/SSISBusiness Intelligence Development Studio (BIDS), Perfmon

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. SSRS/SSIS/BI Developer

Responsibilities:

• Worked wif application users, other developers and business managers to coordinate for Reporting Information.
• Did Solid SQL Server coding, debugging and performance tuning.
• Transformed complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting and implemented an extra level of security by creating views and creating stored procedures to query the confidential data.
• Designed, developed and deployed around 75+ new reports and enhancements to existing Reports, for various applications as assigned using SSRS 2008/2012.
• Created interactive reports for sorting, different parameterized reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Used Shared Datasets and Shared Data sources in various reports which point to the same objects and pulled data from OLTP and OLAP Systems.
• Used OBIEE Add-Ins to insert, deploy, and analyze Reports in Excel and PowerPoint and also OBIEE Objects such as table views and chart views (BI Publisher).
• Involved in Perform analysis, Development, Configuration, Customization, Validation and Deployment for OBIEE
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multivalue, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Scheduled reports for daily, weekly, monthly subscription reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS) 2008/2008 R2.
• Configuration and Deployment of all the Reports (RDL) across various SDLC environments.
• Deployed the solutions on Web Server, Implemented security to restrict the access to users and to allow them to use only certain reports.
• Used Team Foundation Server to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Provided documentation about reporting and Updated functional specification and technical design documents.
• Created Experian and Trillium packages for data cleansing and loaded data.
• Design and develop SSIS 2005/2008 Packages to perform daily Data warehouse loads from various source systems including Flat Files, Excel Files, SQL Server, Informix and Sybase and also used configuration files to execute the packages across different environments.
• Performed ETL using custom tasks like Google Analytics, Informix to load data into the central data warehouse. Used Error Description to handle errors in the packages.
• Created SSIS Packages to perform the daily and weekly processing of SSAS Cubes using Execute Analysis Services Task.
• Deployed the Packages to File System and SQL Server and scheduled them using SQL Agent to run automatically.
• Designed and developed SSIS (ETL) Packages to pull data from Sybase, SQL Server, Flat Files, and Web etc. And load the Core Enterprise Data warehouse Facts and Dimension Tables overnight.
• Used various control flow tasks like Execute SQL Task, Execute Process Task, File System Task, Data Flow Task etc. and also used containers like For Loop, For Each and Sequence Containers.
• Worked wif Data flow tasks like, Excel, OLEDB, and Lookup and also installed custom tasks like Google Analytics Source and pulled data from Web into Data warehouse.
• Created Packages to Process SSAS Cubes using Execute Analysis Service Process Task.
• Scheduled the SSIS (ETL) Packages to run automatically overnight using SQL Server Agent.
• Involved in performing DDM (Dimensional Data Modeling) using MS Visio and created Star and Snow flake schemas which can be used in Enterprise DW and SSAS Cubes.
• Designed over 3 SSAS Cubes for various section of audience in the organization, created Partitions, KPI's, Actions, Roles, Attribute Relationships, Hierarchies etc. in the cubes using Facts and Dimensions.
• Performed Daily Process Update and Weekly Process Full on the Enterprise SSAS Cubes using SSIS Packages and SQL Agent.
• Used Informatica Cloud to extract data from Sales Force to SQL databases and scheduled the jobs in Informatica Agent.
• Designed and developed SSIS Mappings and sessions based on business user requirements and business rules
• Involved in data Extraction and Transformation from various source databases and flat files and Loaded into Data Warehouse using SSIS.
• Created Source and Target definitions, Transformation, Mapplets and Mapping by using Designer.
• Implemented various transformations like Expression, Lookup, Sequence generator, and Source Qualifier, Rank, Aggregator etc. to load the data from Staging area to Data Warehouse.
• Used Workflow Manager to create, run and monitor Sessions.
• Involved in debugging mappings to fix data transformation problems, also involved in tuning Sessions to improve performance.
• Generated Tableau dashboards connecting to different sources like Salesforce/SSAS cubes/SQL databases/Excel/Google Analytics.
• Generated adhoc Tableau reports on demand for business users.
• Generated Tableau reports wif Trend lines.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Performed Tableau admin activities like managing extracts, Creating Sites, access to users and Installations.

Environment: MS SQL Server 2012/2008 R2/2005, Visual Studio 2005/2008/2010, Informatica (9.5),Tableau, Reporting Services (SSRS 2005/2012), Business Intelligence Development Studio (BIDS), Experian, Trillium, MS Office 2010, MS Access, Visual Source Safe,VB.net, SharePoint, Microsoft VSTF, Integration Services (SSIS 2005/2008), Sales Force

Confidential, St.Louis, MO

Sr. SSRS/SSIS Developer

Responsibilities:

• Extensively used ETL Components to Extract Data from Different Sources.
• Designing and development of SSIS packages to fetch data from different data sources.
• Using Lookup's and SCD's to capture the CDC Data.
• Designed and implemented Dimensions and Measures according to business requirement.
• Development of UNIT test cases and prepared technical specifications for SSIS packages.
• Implementation of CDC Techniques and applying standards like logging check points, and package configurations.
• Creation of source Queries at Analysis and Designing phase.
• Preparation of mapping documents and technical design documents based on client requirement specifications.
• Helping Production team for SSIS Packages Migration from Dev to UAT to Prod.
• Working in performance tuning and deployment phase.
• Ensuring quality, timeliness of the project deliverables.
• Creates technical specifications, test plans and test data to support ETL processes.
• Expert in Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins.
• Expert in SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Used Trillium data cleansing packages and loaded cleansed data.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Designed cubes wif star schema using SQL server Analysis services 2008 (SSAS)
• Understanding OLAP process for changing and maintaining the warehouse, Optimizing dimensions, Hierarchies and adding the aggregations to the cube
• Worked on SSRS Reports
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) and .Net data access components.
• Discuss wif the business team to clarify the requirements to get clarity of certain business functionalities.
• Participate in the business team meetings to represent the offshore development team to help the business team wif technical feasibility.
• Responsible for Production, customer issues resolution

Environment: MS BI (SSIS, SSRS and SSAS), Trillium, SQL Server 2008, Attunity, TFS

Confidential, Redmond, WA

SSRS/SSIS/BI Developer

Responsibilities:

• As a member of BI/Database team, Involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Involved in supporting more TEMPthan 70 Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Designed and developed more TEMPthan 100+ enterprise reports(SSRS/Business Objects) using the data from ETL Loads,SSAS Cubes and various heterogeneous data sources.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions.
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS).
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and batch (.bat) files on a day to day basis.
• Experience in configuring wif checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• 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).
• Developed many MDX queries for creating calculated measures dat fits business logic.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server.
• Created official Templates, Mailing Subscriptions and created shared data sources dat can be used across different processes.
• Created Analytical reports by using ProClarity tool.
• Complete administration of Report Server 2005/2008 which involved creating logins, maintaining item level security, managing roles and granting permissions.
• Involved in Database Administration activities like Back up, Security.

Environment: SQL Server 2000, 2005,2008,SSIS,SSRS,SSAS, XML, MS Project, MS Access 2000 & Windows 2K platform, Share Point, Crystal reports, Oracle 9i, C#,.Net

Confidential, San Antonio, TX

SSRS/SSIS/SQL Developer

Responsibilities:

• Actively participated in supporting and enhancing logical design of the system to in corporate changing business and user requirements.
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Involved in writing lots of reports incorporating business logic and user requirement.
• Designed ad-hoc reports, grouping and sorting using SSRS and Crystal Reporting 9.0.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
• Created large enterprise reports for various Business functionalities assigning report parameters.
• Written SSIS packages in 2005 and did conversion DTS packages from
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Developing OLAP cubes using SSAS 2005 and calculate the metrics dat were revealed in the functional analysis.
• Worked on creating calculated measures dat fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes (Star Schema) across all environments.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS)

Environment: SQLServer 2000/2005,SSRS 2000/2005,SSIS/DTS, Visual SourceSafe, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory and Windows XP platform, DOT NET 2.0, DB2 (Main-Frame), VB Script, MS Visio.

Confidential

Database Analyst/Developer

Responsibilities:

• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems like ARIES, TOW,Land,JIB into the databases for Dashboard Reporting on a daily basis
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Expert in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
• Worked on SSRS 2005/2000 to generated lots of reports for various user groups and developer groups.
• Has written Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Created stored procedures to use as the datasets for the Report Design.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports
• Extensively worked on Report coding to behave according to the front end CRM Application.
• Configured Subscriptions and Security for all critical reports.

Environment: Windows2003 Advanced Server, MS SQL Server 2000/2005, TSQL, Visual Basic