SUMMARY

• Over 8+ years of Experience as MSBI and Database developer and Support of Microsoft SQL Server 2005/2008/2012 in Development, Test and Production Environments with various business domains like Financial, Manufacturing, Healthcare applications.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Hands on experience with performing various SSIS data transformation tasks like Look - ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Extensively used SSIS packages to Import data from sources like Oracle, Confidential DB2 AS400 (iSeries), Flat Files, Excel, HTML and Raw Files.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Experienced in Conversion of Complex DTS Packages to SSIS from scratch and also using third party tools like DTS Xchange.
• Good Knowledge of Data Warehouse architecture and attribute relationships between Fact and Dim tables.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating and scheduling SSIS Packages to perform Dimension and Cube Processing.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
• Experience in gathering Business Requirements and translating them into technical specification and creating reports with respect to business requirement.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Experience in Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012.
• Working knowledge in performance point server in developing dashboards, reports, etc.
• Experience in Visual Studio tools like TFS for Source Control
• Efficient in creating Joins and Sub-Queries for complex queries involving multiple tables and basic working knowledge in LAMP stack.
• Experience in Normalization/De-normalization Techniques for optimum performance in relational and dimensional database environments.
• Experience in performing deployment and configuration of packages using .NET commands.
• Performed Duties like new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects.
• Good SQL server administration skills including database creation, backups, disaster recovery, database maintenance, user authorizations and resolving deadlocks.
• Expertise with scheduling and monitoring jobs using SQL Server Agent to perform hourly/daily/monthly data loads.
• Working knowledge in Qlikview business intelligence software and knowledge in retails environment like customer behavioral segmentation, market basket. Etc.
• Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burndown Charts, Backlog Grooming and Retrospective.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and ability to think outside the box.

TECHNICAL SKILLS

SQL Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Profiler, Sybase 12.5 ASE.

Confidential Tools: Confidential DB2

Languages: C, C++, SQL, T-SQL, PL/SQL, Visual Basic 6.0, C#. NET, My SQL, VB.NET, HTML, CSS, AJAX, XMLOperating Systems WINDOWS 95/2000/2003/ XP/VISTA/7/8/8.1/UNIX,LINUX.

Databases: MS-SQL Server 2012/2008 R 2/2008/2005/2000 , MS-Access 2007/2010, Teradata and AS400

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.

Scripting: HTML, DHTML, XML, Shell Scripting, Power Shell 2.0.

Reporting Tools: SSRS, SSAS, Crystal Reports, Report Builder 3.0., Pyramid.

DB Utilities and design tools: SQL Server Management Utility, SQL Profiler, Query Analyzer, MDX scripting.

Application Software: Visual Studio 2008/2012/2012 , SharePoint, SQL dialect, MS Office Tools, TFS.

Methodologies: Agile, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, Nashville TN

MS SQL Server/SSRS/BI Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Configuredpackage logging, error loggingandevent handlingto redirect error rows and fix the errors in SSIS.
• Performed tuning of SQL queries and rewriting queries to improve the performance of database.
• Have migrated data from complex databases into power pivot add on in Microsoft excel and generated reports from them.
• 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 creating SSIS packages with various transformations like Slowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Designed and implemented group by, drilldowns, drill through, Crystal Reports, sub-reports, Parameterized and cascading parameterized reports using SSRS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created statistical charts using Qlikview business intelligence software.
• Created Package Configurations to deploy the packages through DEV, TEST and PROD Environments.
• Created Power Shell Scripts to deploy SSAS XMLA through different environments.
• Utilized TFS to maintain code versions effectively.

ENVIRONMENT: MS SQL Server 2005/2008 R2/2012, MS SQL Integration Services 2008 R2/2012, MS Access, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, Confidential DB2, SQL Server Agent, SharePoint, Visual Studio, TFS.

Confidential, Chicago, IL

MS SQL Server/SSIS, SSRS/BI Developer SQL Server

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SSIS.
• Deployed SSIS packages with a simple one-click deployment to the integration server and also using .NET language.
• Generated parameterized queries in SSRS 2008 R2 using data from SSAS Cubes and various heterogeneous data sources.
• Built Reports in SSRS 2005 and 2008.
• Created the SQL server users and file server users with required permissions by including them in the scripts. Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

ENVIRONMENT: MS SQL Server 2008 R2/2012, Microstrategy, MS Access, MS SQL Integration Services 2008 R2/2012, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, Confidential DB2, SQL Server Agent, SQL Server Reporting Services(SSRS).

Confidential, Warren, NJ

SQL Server/ BI Developer

Responsibilities:

• Created Complex Stored procedures, user defined Functions, Schema Binding Views.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in Query optimization and tuning stored procedures for better performance.
• Created packages in SSIS with error handling.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2012.
• Worked closely with internal customers analyzing problems and to create and maintain reports, maintaining SSRS Reports and ad-hoc SQL scripts.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS 2012.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.

ENVIRONMENT: SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MDS, Netezza database, DQS, DTS, C#, .Net, T-SQL, XML, XD, MS Excel, MS Access, MS visual Studio, BIDS, MS Power Point 2012.

Confidential, Jacksonville, FL

SQL Server/ BI Developer.

Responsibilities:

• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports. Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning and audit analysis on it.
• Migrated database from SQL server 2008 R2 to SQL server 2012 using utilities i.e. exp/imp and attach/detach for SQL servers 2012 futures.

ENVIRONMENT: SQL Server 2008 R2/2012 (SSIS, SSAS, SSRS), MDX, T-SQL, Teradata, SQL Server Analysis Services, EDI, SQL Profiler, VSS, MS Excel 2010, MS Word 2010, Power point 2010, Netezza database, Crystal Reports.