SUMMARY:

• Over 6 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL in Development, Test and Production Environments with insurance, sales and Banking domains.
• Expertise in Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT).
• Experience with T - SQL, Integration Services (SSIS), Reporting Services (SSRS)and working knowledge of Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from .
• Strong knowledge and experience in error handling of SSIS packages using transactions, checkpoints (package restart ability features), break points and error logging procedures.
• Experience in creating and developing different types of reports using SQL Server Reporting Services and Crystal reports and migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MSSQL Server by using BCP and utility.
• Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, schedule reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label.
• Migration of SSRS reports from SQL 2010 to SQL 2012 and 2014.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Keys, Constraints, Indexes, Cursors.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in working/migration of data with SSIS (SQL Server Integration Services) as an ETL tool for Data integration services and business applications.
• Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look-Up, for-each Loop, Multi-Cast, column conversion, Fuzzy Grouping.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub-queries, Complex joins.
• Experience on DMV's and Locking Queries to find out Locks, Deadlocks and Long Running Queries or Transactions.
• Experience in SQL Profiler, Execution Plans, DMV's, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization.
• Experience in MDX to interact with the back end OLAP Services.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Experience on Reports with complex formulas and to query the database for business Intelligence.
• Expert in ETL designing, expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS.
• Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple table’s inner and outer joins, stored procedures.

TECHNICAL SKILLS:

Databases Tools: S SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), BCP, ODBC, SQL OLEDB, Crystal Reports

ETL Tools Data Transformation Services (DTS): E Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: S SQL Server Reporting Services … MS Access, MS Excel, Crystal Reports, Business Objects4.0

Database: MS SQL Server … MS Access, Oracle 9i/8i

P Programming: T-SQL, PL-SQL, C

OOperating Systems: Windows Server, Windows XP, Windows Vista, Linux, Unix

OOther Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), MS AZURE, OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Sr. SQL BI Developer

Responsibilities:

• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Improved performance of SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Extensive experience in extracting, transforming and loading data using SQL Server Integration Services 2008 R2/ 2012. Extracted data from and loaded data into different types of databases and files including OLEDB, ADO.net, excel, flat files, XML and web service sources/destinations.
• Worked with SQL server profiler to generate traces.
• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.
• Used SQL server business Intelligence Development Studio to designs SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.,
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014, calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions
• Expertise in building data warehouses based on star or snowflake schemas, data marts, and staging areas.
• Proficient with SQL Reporting Services 2005/2008R2/2012 such as, building tabular report, matrix report, chart report, parametric reports, linked reports using report designer/report builder 3.0.
• Expertise in creating complex reports like Drill Down and Sub Reports using SQL Server Reporting Service (SSRS).
• Involved in creating report datasets and using stored procedure parameters in SSRS.

Environment: MS SQL Server 2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, MS Azure, SQL Server Management Studio, SQL Server Data Tools (SSDT).

Confidential, Louisville, KY

Sr. SQL BI Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Worked extensively on SSIS packages to implement the data load strategy
• Virtual Machine Backup and Recover from a Recovery Services Vault using Azure PowerShell and Portal.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Created Wrapper utilities using shell scripting, Python to check the data completeness in hive tables.
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Created and Maintained various database in MS Access to track activities and progress.
• Worked on several complex drill-down, parameterized reports and on reports that call sub reports using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution
• Involved in testing, bug fixing and documenting the work for the project at each and every phase

Environment: MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, MS Azure Erwin, Red Gate SQL Source Control.

Confidential, Stockton, CA

Sr. SQL BI Developer

Responsibilities:

• Involved in performing server installation and configuration of SQL Server 2008/R2.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Performed maintenance of Stored Procedures to improve Performance of different front-end applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Produced Metrics for reporting to Senior Management. Used Extract, Transform, Load, (ETL) Concepts to Transform Data into MS Access database to produce reports in MS Excel.
• Developed numerous reports off OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts and multiple datasets.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/R2.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created reports with different features like drill through capabilities, jump to another report, use of pie-charts and bar-charts, usage of tablix (new feature of SSRS 2008), use of filtering conditions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2008 to SQL server 2012
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Modified SSIS ETL package for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
• Involved in migration of data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.

Environment: MS SQL Server 2008/R2/2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), MS Azure, SQL Server Query Analyzer, T-SQL, MS-Access, SSAS, SSIS, SSRS, OLAP, OLTP, MDX, ETL, Erwin, MS Visual Source Safe.

Confidential

SQL BI Developer

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME's and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2005 to SQL server 2008.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Successfully done with migration of data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, MS-Access, MS Azure ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential

SQL BI Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked with SQL queries using MS Access for data manipulations.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 20 (2003, 64-bit edition of SQL server 2000), MS Azure, DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, T-SQL, MS-Access, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.