SUMMARY

• 8+ Years’ Experience in dealing with high volume transactional data in SQL.Strong experience in SQL Development, ETL development using SSIS, Business Intelligence delivery using SSAS, and Reporting solutions using SSRS.
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages.
• Extensive experience in developing tools using Access, VBA.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience writing Distributed Queries between SQL Servers by creating link servers and federated servers.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Data modelling under different schemas like Star Schema and Snow Flake schema.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Create shared dimension tables, measures, hierarchies, levels, cubes, aggregations on MSOLAP/Analysis Server SSAS.
• Creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions
• Developing Custom Report & different types of Tabular Reports, Matrix Reports, Ad hoc reports & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

TECHNICAL SKILLS

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

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

Analysis/Reporting Tools: SSRS, SSAS, Tableau, XML Publisher

ETL Tools: DTS, SSIS, Data Stage, Power BI

Data Modelling Tools: Erwin, Visio

Other Software: MS Office - 2007/2003/2000

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

Database Tools: SQL Query Analyzer, MS Azure SQL Enterprise Manager, Management Studio, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential

Solutions Developer BI

Responsibilities:

• Reviewed many T-SQL issues using management studio for better performance.
• Working on various SSRS reports which are already existed.
• Modifying the old reports and adding subscriptions.
• Automated the old manual reports and getting the updated data from app tracker from the site location.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy the various report items like charts, maps, images, graphs, tables etc. to the R2 report server along with the reports.
• Expert in designing reports using SQL server reporting services (SSRS) & Excel power pivot table based on OLAP Cubes.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.
• Utilized T-SQL daily in creating customs view for data and business analysis.
• Created subscriptions to provide a daily basis reports.
• Worked on SSRS in SharePoint Integrated Mode.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.

Confidential

ETL DW-BI (SSRS /SSIS/SSAS) Developer

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Exposed various capabilities such as Web Services using Restful Framework (Spring MVC Framework)
• Responsible for logical and physical design of SQL Server databases.
• Familiar with SAP BODS and worked with team in creating Batch jobs and running the jobs manually.
• Experience working on Azure SQL Databases and Azure Dataware house.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Using SAP data designer to create work flows, data flows etc.
• Migrated SQL Server 2008 database to windows Azure SQL Database and updated Connection Strings based on this.
• Experienced on creating multiple kind of report in Power BI
• Performed Data Modeling in ER Studio Data Architect 9.0 in the initial stages of the project.
• Developing the power BI reports using the connection string like SQL server, SSAS and T-SQL statements.
• Alter the schema for the required objects. Designed and optimized all the SSIS packages.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Designed the application by implementing Spring framework based on MVC.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Created Ad-hoc reports and cascading reports, Pivot Tables for historical data using SSRS 2008.
• Responsible for creating SQL databases for Power BI and Ad-hoc reports.
• Knowledge connecting Microsoft Power BI Desktop to various data sources. SQL Server is preferable
• Developed drill down and drill through reports from multi-dimensional objects like Star and Snow Flake Schema using SSRS and performance point server.
• Integrated the application with spring framework.
• Involved actively as a part of team for collecting and analyzing the needs of end user requirement.
• Generated various reports with drilldowns, calculated members, and dropdowns from the cubes by connecting to Analysis server from SSRS and Crystal reports.
• Managed and troubleshoot report server related issues.
• Implemented Event Handlers & Error Handling in SSIS packages & notified process results to user communities.
• Knowledge of importing COBOL data structure.
• Configured SQL mail agent for sending the error records to a different team.
• Successfully deployed SSIS (ETL) packages and scheduled jobs.
• Optimizing Stored Procedures & long running SQL queries using indexing strategies & query optimization techniques.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.

Environment: MS SQL, T-SQL,SQL Server 2012/2008R2/2008/2005, SSRS 2012, SSIS 2012,MS Azure, TFS, Java, Visual Studio 2012, XML, XSLT, MS Office, Visual source safe.

Confidential

SQL Developer\MSBI Developer

Responsibilities:

• Regularly supported service packs and hot fixes for both clustered and standalone SQL Server.
• Extensive work developing Stored Procedures, Views, Cursors, Triggers, Scripts, Complex Queries in MS SQL Server.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Utilized Dynamic T-SQL within functions, stored procedures, views, and tables.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Experience in writing DAX in MS Power BI Desktop.
• Develops supply chain management solutions with managers.
• Extensively used BI tools: Integration service, Reporting Services & Analysis services in MS SQL server 2005/2008R2.
• Developed C# scripting for packages.
• Performed most SQL Server Enterprise Manager & Management Studio functionality using T-SQL Scripts &Batches.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Worked with SSIS packages involved FTP, send mail, script tasks, Merge, Merge joining Control Flow Transformations.
• Generated reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Generated Monthly, Yearly, Quarterly and daily reports in Power BI.
• Experienced of 837 and HIPAA standard transactions for claims.
• Extensively involved in Claims submission.
• Provided the required reports in claims according to the goals.
• Developed dashboards using Tableau for demographic information such as population and allow users to drill into geographical objects such state and county information.
• Created various T-SQL scripts for RDBMS applications.
• Implemented Event Handlers & Error Handling in SSIS packages & notified process results to user communities.
• Configured SQL mail agent for sending the error records to a different team.
• Designed rich dashboards with power BI and prepared user stories to create compelling dashboards.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

Environment: ETL, SQL Server 2012/2008R2/2008/2005, SSRS 2012, SSIS 2012, Oracle 9i/10g,Power BI, T-SQL,TFS, Tableau, Visual Studio 2012, XML, XSLT, MS Office, Visual source safe.

Confidential

SQL server Developer/MSBI Developer

Responsibilities:

• Worked with Technical Architects/Database analysts for Design of Summary tables for efficient Report Design.
• Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created SSIS-ETL packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS2008.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Experience in creating complex SSIS-ETL packages using proper control and data flow elements
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS2008.
• Involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Build database queries and test cases for the testing team to test the reports.
• 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.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, ProClarity, MS Excel.

Confidential, CO

SQL Server Developer

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Deployed SSIS packages and Reports to Production Servers.
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SSRS.
• Created/developed stored procedures, triggers, views, &user-defined functions to support application development.
• Deployed and configured the reports in the Report Server.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data, tested database to meet functionalities deliverables in project documentation & specifications.
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential

SQL Server Developer

Responsibilities:

• Worked in the team of developers and designers and handled designing, developing, modifying computer applications
• Worked with Sr. Developers to convert verbal requirements into technical format.
• Modified code and provide extremely complex logic to the code for best results and better performance.
• Used SQL Profiler to monitor the performance of SQL Server.
• Scheduled replication on the databases.
• Actively participated in meetings to decide backup policies for database & perform back up operations on databases.
• Performed Join operations using on large scale database tables.
• Maintained the table performance by following tuning tips like normalization, creating indexes and collect statistics.
• Worked on MS SQL Server tasks such as batch jobs, BCP, DTS linked servers and indexes.
• Created Indexes on database tables to perform the Read operations of the database.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.