TECHNICAL SUMMARY:

• 8+ years of strong experience with demonstrated success working with large - scale database enterprise applications
• Expert in MS SQL Server 2014/2012/2008R2/2008/2005/2000 suite of products like SSRS, SSAS, SSIS, Oracle, IBM DB2.
• Good knowledge in Data integration using ETL tools like SSIS (Microsoft BIDS) and Informatica
• Extensive knowledge in T-SQL queries (DDL and DML)
• Strong experience in designing SSIS packages to transform data between databases and external data sources
• Extensive experience in developing Tables, Stored Procedures, Power BI,Views, Triggers, Pivot tables using Excel, Joins, User- defined functionsand Complex Queries
• Experience in migrating data from heterogeneous databases like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using SSIS / DTS
• Created, Maintained & scheduled various reports in PowerBIlike Tabular Reports
• Expertise in using PowerBIand prepared dashboard reports for internal team progress tracking
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into teh Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access
• Create, modify, document and enhance data specifications including identifying and mapping data elements from source systems into teh dimensional data warehouse. Translate requirements into technical specifications, validate dat teh dimensional data warehouse meets specified requirements
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles
• Perform Analysis, design, coding, testing and implementation of AutoQ solutions for QNXT
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2000/2005/2008/2008 R2/2012
• Installed and maintained Microsoft Reporting Services MSRS on 2000 and SQL Server Reporting Services SSRS 2005 and 2008
• Experience in MSBI suite of products like Power View, Power Pivot, Power Query, Power Map and Crystal reports from Cubes, MDX query/scripts and MDS (master data services) with data mining
• Experience on Teradata and migration to teh SQL Server
• Good understanding of POS products and applications and analytical skills
• Experience in developing Life Cycle using Agile Methodology. Experience in Reporting tools like SSRS and Tableau
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling
• Worked with DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys
• Extensive knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Created and managed Indexes and optimized queries using Query Execution Plan
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, and User defined data types, Cursors and Indexes using T-SQL
• Experience in using T-SQL in SQL Server 2014/2012/2008/2008R2 and previous platforms
• Implemented complex business logic into database design and maintained teh referential integrity
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins
• Reporting Services (SSRS 2005/2008/2008 R2)
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports, Matrix reports and Charts
• Have experience in Crystal reports and power BI
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS
• Experienceingenerating on-demand and scheduledreportsfor business analysis in SSRS
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS)
• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms
• Extensive knowledge in ETL Process & Progressive knowledge in using DTS/ETL/SSIS utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources
• Involved in migration of DTS/ETL Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, and DB2 to MS SQL Server by using Import Export Wizard, DTS/ETL SSIS, and BCP & Bulk Insert utilities
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc and created various user roles
• Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Developed and deployed OLAP cubes using SQL Server Analysis Services (SSAS) 2012/2008R2/2008/2005
• Experience in developing physical database architecture using ERwin Data Modeler and MS Visio 2003/2007
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports
• Created Dashboard pages in Performance Point Server dat use different types of web parts and excel services for reports

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012, 2008 R2, 2008, 2005 & 2000 & 7.0, ADABAS, MS-Access 2000/2003/2007, MySQL.

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS, SSAS, SSRS, DTS/ETL/Informatica, AZURE,CRM,BCP, Business Intelligence Studio, Ad-hoc reports.

Languages: C, C++, VB, C#, XHTML, PHP, T-SQL, Dynamic SQL, PowerShell, XML, CMD, VB.

OS: Windows 2007, Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP.

Web Servers: IIS 5.0, Apache, Tomcat, SharePoint 2007.

Other Tools: Erwin, Microsoft Visual Studio 2003/2005/2008, Microsoft Visio, Microsoft Visual Source Safe, MS-Front Page, FTP, MS-Outlook Express TFS, FACETS 5.01 and SVN tortoise.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, ROLAP, MOLAP and OLTP.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

MS SQL BI Developer

Responsibilities:

• Worked as a prod support team member and involved in installation and configuration of MS SQL Server 2012/2014 and IBM DB2
• Involved in database development and design using OLTP and OLAP systems (SSIS) using Data tools 2010
• Extracted data using SSIS packages (ETL) from different server locations and data sources
• Created DTS/ETL package to schedule teh jobs for batch processing
• Worked closely with customers and IT management and staff to provide application development and production support. Designs, codes, tests, debugs and documents considering computer equipment capacity and limitations, software alternatives, operating time and desired results.
• Performed research and evaluated alternative solutions and recommended teh most efficient and cost effective application programming solution
• Wrote hundreds of stored procedures and function on numerous SQL server to use in SSIS package andPowerBI
• Supported and maintained ADABAS test and production databases and assisted mainframe developers during new product developments
• Performed routine database maintenance functions as DBA for Oracle and ADABAS as needed
• Coded new or modified programs, reuse existing code through teh use of program development software alternatives and/or integrates purchased solutions
• Installed and configured Oracle 11gR2 Grid Infrastructure/Real Application Cluster (RAC), Oracle 11gR2 and Oracle 12c RDBMS, Enterprise Manager 12c, and Golden Gate 11g
• Highly proficient in teh use of DAX queries for developing complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing
• Analyzed, troubleshot and resolved complex production application defects
• Identified root cause and devised and implemented permanent solutions to recurring defects
• Monitored production jobs and environments and performed in-depth data and systems analysis
• Involved in implementing Star schema for teh data warehouse
• Collaborated with business users, data services team members and other developers throughout teh organization to help everyone understand issues dat affect teh data warehouse
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports using SSRS
• Used cascaded parameters to generate a report from two different Data Sets using report builder 3.0
• Worked on Crystal reports, Dashboards and most of teh reporting needed by teh business
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports
• Analyze business user needs and provided optimal technical solutions
• Coded new programs, enhanced existing programs and/or integrated packaged vendor solutions with existing systems
• Effectively prioritized work while considering business need and urgency
• Developed and automated a migration script using Unix Shell and PL/SQL to ensure all database objects are synchronized in each environment, reviewed, corrected, and performance tuned developer’s scripts (SQL, PL/SQL) and managed all migration efforts while following teh CM process.
• Data model structures and implementations according to teh requirement
• Worked effectively and efficiently on multiple tasks and deadlines and produced high quality results
• Documented, tested (unit and integration), implemented and provided on-going support for teh applications
• Followed SDLC standards, source code management, and release management procedures
• Provided rotational weekly 24 X 7 on-call support for critical applications
• Smart Solve CAPA hands-on experience, verify dat CAPA system procedure(s) dat address teh requirements of teh quality actions were effective and verified or validated
• Had some opportunity to learn and support new technologies, Worked with Azure application and UNIX as well

Environment: T-SQL, MS SQL server 2012, MS Power BI, 2008R2, SSDT, Soap UI, VB.NET, EXCEL.

Confidential, Nashville, TN

MS SQL BI Developer/ETL

Responsibilities:

• Involved in database development and creating SQL scripts. Also experience writing complex T-SQL queries to support needs from business
• Involved in Requirement Study, TDD Creation, UI Design, Development, Implementation, code Review, Validation & Testing, Deployment and client interactions
• Worked closely with customers and IT management and staff to provide application development and production support
• Helped to support teh Application suit within Quotit for open enrollment period and did some UAT testing for teh applications
• Created PowerBIDashboards to show KPI's in teh project
• Create reports in PowerBIpreview portal utilizing theSSASTabular via Analysis connector
• Responsible for Data Migration of health insurance (Action) from SQL server 2000 to 2005 using SSIS via Microsoft management studio 2005 and writing some reports using Microsoft SQL server business intelligence studio.
• Created calculated measures and dimension members using multi-dimensional expression (MDX)
• Used MSRS harvest tool to check-in and check-out of teh code or rdl file to store, run, view, edit and revert back to different versions of teh design in case of a system crash
• Defined High Level Data Architecture for ETL & BI Solutions & Framework Design, Prototyping, ETL Loading Strategy Definition, Data stage, Data Governance & RDBMS standards definition and enforcement, Definition of Data stage Best Practices & Coding Standards
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for teh application
• Analyzing SQL data, identifying issues, and modifying teh SQL scripts to fix teh issues
• Review every day applications and make sure they are accepted
• Tuned and Optimized SQL Queries using execution plan and profiler
• Used SOAP UI calls, T-SQL to run daily tasks and provide daily report to business and IT at teh end of each day

Environment: T-SQL, MS SQL server 2014, 2012, 2008R2, MS Power BI, SSDT, SSIS, SSRS, Oracle 10g/11g/12c, Tableau, Crystal reports, VB.NET, UNIX, EXCEL.

Confidential, Minnesota

MS SQL BI Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference. Involved in installation and configuration of MS SQL Server 2008/2012
• Set up and maintained databases for clients in ADABAS environment provided system analysis, design documentation and time estimates for all user requests
• Involved in designing database and performing forward engineering, data migration, data modelling from conceptual data model to Logical and physical data model using Erwin 7.2 data modeller tool
• Created staging and consolidation tables form logical models
• Created check constraints to maintain data integrity
• Worked directly with teh Azure Product team in tracking and resolving defects in teh beta Azure offerings
• Generated reports using teh Crystal Reports and Reporting Services 2008/2012, Designed and developed matrix, tabular and parametric reports in teh SQL Server Reporting Services 2008/2012.
• Used SQL Server 2014 for supporting old codes.
• Migrated some Crystal reports to SSRS reports manually
• Extensive experience in developing Tables, Stored Procedures,Views, Triggers, Pivot tables using Excel, Joins, User- defined functionsand Complex Queries on SQL Server 2008/2012
• Analyzed, designed, enhanced and tested on-line, batch programs in summons tracking and receiving systems (STARS) using Natural and COBOL in Adabas environment
• Populate or refresh Teradata tables using Fast load & Fast export utilities for user Acceptance testing and loading history data into Teradata
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Wrote complex Queries, Triggers, User-defined functions as per teh business requirements
• Involved in migrating data from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database
• Extracted data using Azure services and also build Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.
• Specialized in Healthcare software QNXT web based application using VS.NET, PowerShell,C#, JavaScript, LINQ, VB, IE 4 and up, SQL Server all versions and Team Developer Environment
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from teh existing diversified data sources
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data
• Designed high level SSIS architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh SSAS cubes
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS)
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS)
• Used MDX to create calculated members in teh cube
• Operational and summary reporting framework design and development (MDX, PowerPivot, DAX, SSRS, ProClarity, Crystal Reports)
• Extensively involved in teh SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008 Analysis Services.
• Implemented teh Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Drill down, Drill through, Sub reports in SSRS

Environment: MS SQL Server 2014/2012/2008R2, T-SQL, QNXT, .NET, C#, SSRS, SSIS, SSAS, MS Performance Point Server 2007, MS Share Point Server, Azure, MS Access and Excel.

Confidential, North Carolina

MS SQL Server Developer

Responsibilities:

• Involved in Logical & Physical Data modelling
• Involved in writing stored procedures, Triggers, User-defined Functions, Views
• Created SSIS packages to load teh Enterprise Data Warehouse
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Design and Develop Databases for different systems and Data was populated by SSIS Packages
• Implemented table partitioning (SQL Server 2000) on tables in excess of 300 GB increasing load performance by more than 800 percent and report performance by more than 60 percent
• Created indexes and proper re-indexing for intensive OLTP system to ensure best performance
• Worked with SQL 2005 Advanced features like CTE’s, Except, Intersect, Pivot and Un-pivot
• Performed ongoing monitoring and refinement of database queries and ETL programs
• Created database objects including tables, triggers, views, stored procedures, indexes, defaults and rules
• Set database access privileges for different users and user groups
• Used various Control Flow tasks such as Execute SQL Task, Script Task and Data Flow tasks such as Lookup, Derived column and Script Component
• Created reports for managers and end-users for strategic planning purposes
• Responsible for maintaining database in excess of 1TB in respect to performance backup times san architecture and archiving data
• Performed query optimization and checked performance tuning
• Experience in Tableau and Qlikview Dashboards in latest Design and Presentation
• 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
• Purchased, set up, and configured a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose
• Performed Error Handling using Event Handlers and also used in built Error Description to capture redirected errors
• Experienced in working with SQL 2005/2008/2012, SSIS, Reporting and Analysis Services
• Supported teh Director of Business Information in their interactions with key stakeholders to define, design and develop critical reporting needs using SQL Server Reporting Services 2005/2008/2012.
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems
• 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
• Uploaded reports to Azure cloud services for teh future use.
• Created a Virtual Network on Windows Azure to connect all teh servers
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler
• Integrated Excel Services and SSRS Reports to SharePoint for BI reporting
• Maintained and developed SQL DTS solutions to format and report data imported from all 350 stores in company
• Imported scheduling data to report in store manager schedules
• Developed and maintained DTS used to gather and format data to report all store financial information to deliver via hard copy and CD format
• Maintained and developed all intranet reporting and applications for all stores, District Managers, Regional Managers
• Maintained grid system intended to monitor each unit’s sales, profit, food cost and payroll expenditure
• Created and maintained a set of calendars utilized by Regional and District managers to display store visit schedules and areas of focus using SQL Server stored procedures and triggers and VBScript and classic ASP
• Created and maintained all maintenance technician information and provide a manner for each technician to access maintenance work lists for individual stores using ASP, VBScript and T-SQL programming and SQL stored procedures to gather data
• Created cubes on data warehouse
• Documented teh process flow and logic to move data from staging to data warehouse
• Created Data warehouse models using star and show flake schema to store data in dimensional approach
• Maintained web portal used to access Corporate information schedule meeting rooms search employee information and post corporate announcements and access operational data

Environment: MS SQL Server 2008R2, T-SQL, SSIS 2008, SSRS 2008, TFS 2010, Advanced Server, SSMS, ASP.Net.

Confidential

MS SQL Server/SSIS/SSRS/ BI Developer

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs
• Tuned and Optimized SQL Queries using execution plan and profiler
• Given Training to Client on pivot Table Reports in Excel using stored procedures
• Created complex SSIS packages and SSRS Reports from Stored Procedures, Views and by writing complexT-SQL
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution
• Extensively designed and developed reusable transformations & aggregations and created target mappings dat contain business rules
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server
• Imported and exported data from one server to other servers using tools like Data Transformation Services (DTS/ETL)
• Created DTS/ETL package to schedule teh jobs for batch processing
• Configured Server for sending automatic mails to teh respective people when a DTS/ETL process failure or success
• Performed development support, document reviews, test plan, integration of teh system

Environment: MS SQL Server 2000/2005, SSRS, SSIS, SharePoint Server 2007, OLAP, Erwin 7.0, DTS/ETL/SSIS, BIDS.