SUMMARY

• Over 8 years of extensive experience in Database design, development and administration of applications with MS SQL Server versions 2014/2012/2008 R 2/2008/2005/2000 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, Triggers using T - SQL(DML and DDL) as well as analyzing and debugging existing complex stored procedures
• Strong working experience on SQL including DTS, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in integrating SSRS reports into external applications using report viewer controls and custom URLs.
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008.
• Experienced in merging data from various heterogeneous data sources, Populating Dimension and Fact tables in data warehouses and data marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations
• Experience in extracting and transforming data using DTS Import/Export Wizards, Bulk Insert, BCP and SQLServer Integration Services (SSIS) packages and scheduled jobs, alerts, DTS/SSIS Packages in SQLserver.
• Migrate various formats like text based files, Excel spreadsheets to SQLServer databases using SQLServer Integration Services (SSIS) to overcome the transformation constraints.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views and Deploying and Processing SSAS objects.
• Well Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Solid experience in version control tools such as Team Foundation Server (TFS) and Sub version (SVN).
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
• Strong communication and team-oriented skills with a strong attitude toward learning new technology quickly supporting the project requirement.

TECHNICAL SKILLS

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, HTML.

Databases: SQL Server 2012/2008R 2/2008/2005/2000, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2013/2007/2003, Active Batch, Red Gate

Operating Systems: Windows / 98/2000/2003/2007/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005/2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Red Gate, TFS

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, California

SQL BI Developer

Responsibilities:

• Creating and defining the SQL Servers (Dev, QA and Prod) and Databases in SQL server 2014 with the Architecture in the team.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views,SQLjoins and other T-SQLcode to implement business rules.
• Expertise in writing T-SQLQueriesusing Joins, Subqueriesin MSSQLserver …
• Strong experience in writing stored procedures, functions, triggers in MS T-SQLbuilding the packages, Testing and implementing in the production server.
• Redesigned and tuned stored procedures, triggers, UDF, views, indexes and was successfully able to increase the performance of the slow runningqueries.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Developed ETL packages using multiple data sources (SQLServer, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Created Master SSIS packages in order to execute a set of packages on a timely basis and deployed those packages using Manifest Files and Import/Export Wizard so that the packages were available for use of other team members.
• Experience in Error and Event Handling: Precedence Constraints, BreakPoints, CheckPoints, and Logging using SSIS.
• Extensive experience with multiple development environment including SQL server Server 2005/2008/2008 R2/2012/2014 Visual Studio (BIDS) 2005/2008/2010, TeamFoundationServer(TFS) 2008/2010, and SharePoint 2010
• Monitor productionserversusing Red Gate tools and SQLServer by using Red Gate SQL monitor. And comparing all the databases and tables by using SQL Compare 11.
• Used to run the jobs by Active Batch, which it is more advanced to run the jobs in SSMS.
• Created, updated and maintained ETL Technical Documentation for future reference by other team members.
• Identified, tested, and resolved performance issues of poorly runningqueriesand performance of database itself by using Index Tuning Wizard,SQLProfiler, andQueryAnalyzer. Also monitored Deadlocks inSQLserver usingSQLServer Profiler.
• Experience in T-SQLProgramming skills, Experience in query optimization & performance tuning. UsedSQLProfiler, Execution Plan, Performance Monitor, Diagnostic Manager, and DBCC Commands.
• Monitoring the data files, log file space issues, blockings, TempDB space issues.
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups

Environment: SQL Server 2014/2008R2/2008, SSRS 2008, SSIS 2014/2012/2008, Data Stage, DB2, Oracle 9i/10g, Visual Studio 2005, Active Batch, Red Gate, Team Foundation Server(TFS), XML, XSLT, MS Office and Visual source safe.

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business needs for insights & analytics.
• Assisted DBA in architecting, developing, validating BI solutions such as reports, dashboards, KPIs and alerts.
• Created SSIS package to extract, transform and load data into the Data warehouse and Report-Data mart.
• Gathered Requirements, Analysis and Documentation for creating reports. Analyzed complex technical requirements and made determinations for modifications of existing programs/modules.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Developed conceptual, logical and physical data models for creating schemas using MS Visio. Created Star/Snowflake Schema for Data Marts.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Generated daily, weekly and monthly reports using SSRS 2008.
• Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System.
• Analyzing long running slow queries and tune the same to optimize application and system performance.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Scheduled jobs for backup, and created alerts for error reporting.
• Designed extract, transform and load (ETL) packages to load business retail data received from different stores and other locations into data marts using Data Flow Task, Execute SQL Task, Lookups, Fuzzy Lookups, Conditional Split, Derived Column and Execute Package Task.
• Designed and implemented data structures for new functionality and restructured existing data structures to increase performance by writing queries and stored procedures.
• Created SSIS packages to automate maintenance, database backup and restoration, update statistics, re-build indexes as well as create error log for event during data load.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created and remediated SSRS reports and publish in SharePoint.
• Researched and resolved complex issues and implemented longer-term solutions to frequent occurring issues.
• Conveyed problems, solutions, updates and project status to peers and management. Developed and maintained clear and succinct documentation.

Environment: MS SQL Server 2008/2012, MS SQL Server Reporting Services (SSRS) 2008R2/2012, TFS, MS SQL Server Integration Services (SSIS) 2008R2/2012, MS SQL Server Analysis Services (SSAS) 2008R2/2012, C#, Power shell, Microsoft Visual Studio, C#, ASP.NET, SharePoint, MS Excel., MS Visio 2013.

Confidential, Macon, GA

SQL Server developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed source/target analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Used the SSIS ActiveX script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Created package configuration by using environment variables.
• Configured and maintained report manager and report server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports
• Performed T-SQLtuning, optimization of queries for reports that took longer execution time using MS SQLProfiler, Index Tuning Wizard & SQL Query.
• Used data compression techniques for Back Up.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Performed CDC and Change tracking on OLTP systems
• Created OLAP cubes & wrote MDX queries for user reports.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: MS SQLServer 2005/2008, SQLServer Integration Services (SSIS), SSAS, SQL Server Reporting Services (SSRS), OLAP, OLTP, SQLServer Enterprise Manager, T-SQL, MS Office Share-Point Server, SQLServer Query Analyzer, SQLProfiler, MS Access

Confidential

SQL Server BI Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents
• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules
• Designed and implemented Stored Procedures and Triggers for automating tasks
• Managed all indexing, debugging, optimization and performance tuning using T-SQL
• Wrote T-SQLqueries, Store Procedures and used them to build packages.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse
• Created configuration packages in SSIS to move the package from development server to production server
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS
• Installed MS SQLServer and Management tools using MS SQL Server Setup Program
• Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server
• Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server
• Ran and tested required queries and reports before publishing
• Published the reports and scheduled the reports in different formats (Email, Public folder)
• Scheduled the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.
• Created a number of complex formulas to find the capacity levels of different servers.
• Scheduled tasks to run every day to update changes in the base tables.

Environment: MS SQL Server, SSRS, SSIS, SSMS, T-SQL, Access and Excel.

Confidential

SQL Server Developer

Responsibilities:

• Developing test plan and test strategy
• Defined various facts and dimensions in the data mart including Fact Less Facts and designed the Data Mart defining Entities, Attributes and relationships between them.
• Review of the test cases written for unit and integration level
• Responsible for overseeing the Quality procedures related to the project
• Generating reports using crystal reports
• Reviewed and fine-tuned T-SQL Stored procedures and triggers before production migration.
• Involved in working on Tables, Constraints, Records and Collections.
• Involved in writing on T-SQL Scripts using common table expression to apply business logics.
• Writing RTMs before the test planning phase Analysis of the specifications provided by the users
• Effective coordination between development team and testing team
• Data conversions and data loads from various databases and file structure.
• Implemented and maintained database security

Environment: Visual Basic 6.0, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft Word, Management studio, SQLServer Reporting Services (SSRS) and HTML