SUMMARY

• Around 9 Years of IT Experience in Database Design Development, ETL Implementation and support of OLTP/Datawarehouse systems using Microsoft SQL Server 2012/20 across various SDLC environments
• Extensive hands - on experience in developing ETL interfaces using SSIS, Datamarts/cubes using SSAS and enterprise reports using SSRS/Crystal utilizing latest versions ( 2005/2008/2012 ) & features
• Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, RequirementGathering, Design, Development, Implementation and Testingand Development experience.
• Extensively worked logical & physical Data modeling, data architecture design, Normalization andDe-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema)
• Involved in Designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, Unique),Indexes, defaults, rules
• Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions, ViewsUsing SQL
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Complex joins
• Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, EfficientCoding standards.
• Data migrating (using ETL tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012 ), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Good knowledge of 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 SQL Server Analysis Services (SSAS)
• Expertise in Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modelling, Physical Modelling, Dimensional Data Modelling, Star Schema, Snowflake Schema, FACT tables, Dimension tables.
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/2008) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Developed cubes using Partitions, KPI’s, and Perspectives, slowly changing dimensions etc and created various user roles.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience standardizing the enterprise data with Master Data Services to help make critical business decisions
• Creating and Managing users, roles and assigning necessary permissions
• Created Dashboard/Scorecard pages in SharePoint Server/MOSS 2007/Performance point server that use different types of web parts and excel services for reports
• Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards
• Excellent communication and interpersonal skills and has ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows XP/ 2000/2003/2008/ NT 4.0/9x/Vista and MS-DOS, UNIX

RDBMS: MS SQL Server 2000/2005/2008 , MS Access 97/2003/2005 , Oracle8i/9i/10g

LANGUAGES: T-SQL, PL/SQL, MDX, C, ASP.net, VB.net, C# (.NET)

WEB TECHNOLOGIES: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0)

TOOLS: AND PACKAGES SQL Server Management studio, Enterprise Manager, Profiler, SQL

Server Business Intelligence: Development Studio (BIDS), DTS, SSIS,Crystal Reports9.0, Informatica 6.x, Visual SourceSafe6.0, TeamFoundation Server, Visual Studio .NET, ETL, ProClarity

DATABASE DESIGN TOOLS: MS Visio, Erwin4.5/4.0

BI TOOLS: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Business Intelligence

Development: Studio (BIDS), Visual Studio, Crystal Reports, Cognos

PROFESSIONAL EXPERIENCE

Confidential, TX

Senior BI/SQL Developer

Responsibilities:

• The Projects involved integrating systems from Confidential, SBC and various systems, which used Microsoft SQL Server 2012/2008/2005 and Microsoft 2005, advanced datacenter servers.
• The systems dealt with building Reporting EDW using SSIS.SSRS and Excel apart from supporting ad-hoc client needs.
• Worked with various teams and User groups in designing and developing the Reporting warehouse for the Confidential Learning Solutions
• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings
• Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations
• Involved in writing heavy T-SQL stored procedures, complex joins, new SQL2008 T-SQL features like Merge, Except commands
• Supported 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
• Developed differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and data cleansing from different Sources into Company Formats
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Migrated data from various data sources like Oracle, Flatfiles, Teradata into Staging, reporting databases using DTS/SSIS.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Responsible for Dimensional modeling. Defined relationships between Dimensions and Measure groups.
• Created SSAS cubes and loaded dimensions and facts. Defined attribute properties in a Parent Child Dimensions.
• Created the data source views and defined granularity with in a measure group and drill through actions.
• Reviewed cubes, changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
• Created Reports, Scorecards, and Dashboards using SSRS
• Worked with installation, configuration and deployment of SQLServer Reporting Services (SSRS), developed various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
• Worked with SSRS 2008 Report Builder and allow customers build their reports using Report Builder.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler etc.
• Involved in Monitoringand 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
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views
• Deployed reports across Test, Developmentand Production Environments
• Involved in Trouble Shooting Complex Reports
• Created Large Number of Report Models for users to create their own reports
• Involved in code reviews, change control and auditing procedures

Tools: and Technologies: T-SQL, PL/SQL, MS SQL Server 2012/2008/2005 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MDS, ETL, MS Excel, MS Access, Teradata, Windows Server 2008/2003, Oracle9i, VBScript.

Confidential, TX

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

Responsibilities:

• Involved in EPC Data Warehouse development starting from inception to implementation and ongoing Support
• Involved in Designing architecture of the warehouse, Logical & Physical Data modeling, data Dictionary mappings
• Involved in writing various DB Objects like User defined functions, Views, 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
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by Performing different kinds of transformations like Lookup Transformations, Merge Joins, Fuzzy Look Ups,Derived Columns, Merge Join, Conditional Split, Data Conversion with Multiple Data Flow tasks
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task FailedEvent Types Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQLTable and log files
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party Tools
• Involved in Monitoringand troubleshooting complex packages by using Data Viewers Grids, Debugging and
• Maintenance of ETL packages and ETL optimization using SQL Server best practices
• Configured, Installed, Administered Reporting Services 2005/2008
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through/DrillDown Reports and Created Large Number of Report Models for users to create their own reports.
• Deployed the solutions on Web Server, Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions
• Worked on Dimensional Data Modeling using Star and snowflake schemas for Fact and Dimension tables
• Involved in optimization of Data Models using Kimball Methodology
• DevelopedOLAP Cubes by using SQL Analysis Services (SSAS)and and defined Data Sources, Data Source Views, Dimensions, Measures, Hierarchies, Attributes, Calculations, KPI’s, Perspectives and Roles.
• Extensively involved in theSSAS storagemethods (MOLAP, HOLAP, and ROLAP), partitions, andaggregations, calculation of queries, Data Mining Models, developing reports using MDX and SQL.
• Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill downReports, report models, KPI’s and Dashboard/Scorecard reports.
• Created and modified Dashboard pages in SharePoint server that use Excel Web Access web parts and reporting services web parts and Used Excel Services for reports and we parts
• Used Team Foundation Server to store, run, view, edit and revert back to different versions of the design and development phases
• Provided documentation about database/data warehouse structures and updated functional specification and technical design documents.
• Involved in code reviews, change control and auditing procedures

Tools: and Technologies: T-SQL, PL/SQL, MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), ETL, MS Excel, Team Foundation Server, Windows Server 2008/2003, Oracle9i, VBScript.

Confidential

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005) and Excel pivot tables based on OLAP cubes which make use of multilple value section in parameters pick list, cascading promtps, matrix dynamics reports and other features of Reporting service.
• Built Drill Down, Drill through, linked and subreports using SSRS 2005/2008.
• 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.
• Created Data-data packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services (SSIS)
• Scheduling and Maintaining SSIS Packages and batch jobs thru SQL Server Agent and using Shell Scripts, VB Script and batch (.bat) files on a day to day basis
• Experience in configuring with 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 measures that fits business logic
• Worked on Key performance Indicators (KPIs), design of Star schema and snowflake schema in Analysis Services (SSAS)
• Published reports on to the Sharepoint and created Webparts in Share-point to show various reports generated from Excel and SSRS in one web part page
• Created forms on share-point to show livedata from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data int o the underlying data sources.

Tools: and Technologies: Sql Server 2005/2008,SSIS, SSRS, SSAS, XML, MS Project, MS Access 2000 and Windows 2k platform, Sharepoint, Crystal reports

Confidential, St Louis MO

SQL Developer (SSRS/SSIS/ SSAS/SQL)

Responsibilities:

• Analyze client requirements and translate them into technical requirements.
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes
• For accomplishing various tasks, worked on Performance tuning queries by looking at the Indexes, Appropriate joins, Query Statistics and Execution plans
• Created SSIS/DTS Packages from various heterogeneous source systems like Oracle, SQL Server, Flat Files
• And Excel Spreadsheets into the destination databases for Dashboard Reporting on a daily basis
• 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
• Created master ETL packages with multiple packages and scheduled them to execute based on the given requirement time
• 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
• Developing OLAP cubes using SSAS 2005 and calculates the metrics that were revealed in the functional analysis.
• Provided strategies and the Data Warehousing Best Practices based on Kimball methodology
• Worked on creating calculated measures that fits business logic, using MDX queries
• Handling Initial and Delta loads and processing Cubes across all environments
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS)
• Involved in writing lots of reports incorporating business logic and user requirement.
• Created stored procedures to use as the datasets for the Report Design.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• 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 huge number of report models for users to build their customized reports.
• Configured report subscriptions like Time Driven and Data Driven subscriptions.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint
• Integrated SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS)
• Created Scorecards based on Key Performance Indicators(KPI’s), and generate KPI Score-card dashboard and pivot tables/charts for decision making, data mining
• Deployed and uploaded the SSRS reports to SharePoint Server/ProClarity for the end users to look at them.
• Creates technical specifications, test plans and test data to support ETL processes
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.

Tools: and Technologies: MS SQL Server 2005, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), Data Transformation services (DTS), ETL, MDX, Microsoft Office SharePoint Server (MOSS) 2007, Performance Point Server 2007, ProClarity, Microsoft.NET (Asp .NET, C# .Net), Visual Source Safe, Toad, Oracle 10g

Confidential, FL

SSRS/SSIS/SQL Developer

Responsibilities:

• Gathered and documented business requirements, Security requirements, Enterprise DataSources and External Data Feeds.
• Designed Technical Architecture (Dimensional Modeling, Physical Design, ETL Development) Designed
• Snowflake Schema based on the assessment for end user reporting and Analysis needs.
• Developed Business Analysis Applications and Ad-Hoc/Custom reports using SSRS 2000/2005.
• Migrated Oracle 10g Databases, PL/SQL Scripts to SQL 2000/2005.
• Installed SQL 2005 and all necessary tools in the Development, Staging, and Production environments.
• Installed and utilized the Oracle 10g .Net Data Provider for use with SQL 2005 and VS.Net 2005.
• Upgraded SQL 2000 DTS (ETL) to the new SQL Server Integration Services SQL 2005 (SSIS) format.
• Designed Complex SSIS packages interfacing SQL with Oracle 10g.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the
• Performance of databases.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Migrated Crystal reports to SSRS reports. Also Created Parameterized reports and linked reports using Bookmark links, Drill through links and Hyperlinks.

Tools: and Technologies: MS SQL Server 2000/2005, Windows server 2003, Business Intelligence Development studio (SSRS and SSIS), Microsoft.NET, MS Office Access 2003, VBScript, Erwin, and Visual Studio 2005.

Confidential, UT

SQL Developer (SSRS/SSIS/ SQL)

Responsibilities:

• As a member of Database and BI Reporting team, extensively worked on T-SQLs, Data loads and Reports
• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
• Experience in DTS for data flow from source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating s.
• Experience with Distributed transactions building linked servers, complex queries, error handling using SAVEPOINT in OLTP transactions.
• Creating Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Experience in creating, debugging DTS packages using Active X Task, dynamic properties task to for file check, sending mails upon package completion, and file archiving.
• Designed DTS package, with DTS Import/Export wizard for transferring data
• Data migration (Import & Export - BCP) from text to SQL Server
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc

Tools: and Technologies: T-SQL, MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Analysis Services 2000, MS Access 2000 & Windows NT platform, Reporting Services, Crystal Report 8.0, DTS

Confidential

SQL Developer

Responsibilities:

• Involved in Creating Database Objects like Tables, Stored Procedures, Views, Triggers, and user definedFunctions for this project.
• Analyze the client requirements and translate them into technical requirements.
• Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2000
• Experience in DTS for data flow from source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Designed DTS package, with DTS Import/Export wizard for transferring data
• Data migration (Import & Export - BCP) from text to SQL Server
• Responsible for creating reports based on the requirements using Reporting Services 2000.
• Identified the database tables for defining the queries for the reports.
• Defined report layouts for formatting the report design as per the need.
• Identified and defined the Datasets for report generation.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Identified and included report parameters for parameterized report.
• Formatted the reports using Global variables and expressions.
• Deployed generated reports onto the Report Server to access it through browser.
• Maintained data integrity by performing validation checks.
• Optimized queries, tuned and monitored server performance

Tools: and Technologies: MS SQL 2000, Windows server 2000, SQL Query Analyzer and Enterprise Manager, MSAccess 2000 & Windows NT platform.