SUMMARY

• Over 5+ years of IT experience as a MS SQL Server Developer 2012/2008 R 2/2008/2005/2000 and Oracle 10G in various Industry verticals like HealthCare, Insurance, Banking, Law Firm and Software.
• Experienced in designing and creating reports and Dashboards using Tableau Desktop and Crystal Reports.
• Extensive experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• Experience in developing the applications usingT-SQL Programming (DDL, DML, and DCL). Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Extensive experience in MS SQL Server 2008 R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.
• Experienced in scheduling SSIS Packages and stored procedures with SQL server agent, windows batch file script and Dollar Universe
• Strong experience working with BCP, DTS in SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages. Experienced in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Expert in creating and deploying SSRS reports on the portal for user accessibility. Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Strong experience in logical and physical database design and development using Erwin and SQL server enterprise manager. Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R 2/2008//2005/2000 , 7.0, Oracle 11g/10g/9i/8i/7.x, MS Access, DB2, Teradata.

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer, Dollar Universe

ETL Tools: SSIS 2012/2008R2/2008/2005, DTS, BCP (Bulk Copy Program)

Reporting Tools: Tableau 8/9/10/10.5, SQL Server Reporting Services 2008R 2/2008/2005/2000 (SSRS), Crystal Reports Performance Point Server 2007, Report Builder.

OLAP Tools: SQL Server Analysis Services 2008/2005

Programming Languages: SQL, T-SQL, PL/SQL.

Data Modeling: ERWIN, MS Visio, ProClarity

Operating Systems: UNIX (Solaris/Linux/AIX), Windows (95/NT/2000/XP)

Packages: Microsoft Office

Web Development Tool: HTML, XML, Visual Studio 2008/2010/2012

Version Control: Microsoft Team Foundation Server, Visual Source Safe

Development Methodology: Agile

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel NJ

Report Analyst/Tableau Developer

Responsibilities:

• Responsible for designing and creating reports and Dashboard using Tableau Desktop.
• Responsible for creating database objects like tables and stored procedures using T-SQL to feed into tableau extract and live data connection to the reports.
• Responsible for creating tableau extracts and set the refresh schedule from database tables and stored procedures.
• Modified existing crystal dashboards/reports and their data source on demand to meet new requirement.
• Modified and troubleshoot existing Intellicus reports using Intellicus Studio.
• Monitored and tuned the performances of the vizzes to meet client expectation.
• Member of an Agile development sprint team that has every 2 weeks sprint and monthly release.
• Worked closely with Front End Java developer of various web application to feed the vizzes into the website and space they have given.
• Created and modified Stored Procedures, Function, Tables etc. to feed into the reports to meet client requirement.
• Responsible for monitoring and refreshing sql jobs and tableau extracts to make sure the data appearing in vizzes are correct and current.
• Responsible for familiarizing tableau visualization and the data flow to newer member of the team and helping them with their needs.
• Applied tableau vizzes best practices to make reports and dashboard optimal and most performing.
• Created multiple tabbed dashboard with several views on each dashboard with a dataset having more than 120 million row on it.

Environment: Microsoft SQL Server 2012/2014, Tableau Server/desktop 8.5/9/10/10.5 , Crystal Reports, Intellicus server/Studio, MS office

Confidential, Richmond VA

SQL Developer

Responsibilities:

• Responsible for creating database objects like tables, Views, Store Procedures, Triggers, Functions etc from scratch using T-SQL to provide structure to store data and to maintain database efficiently for new web applications.
• Modified existing database objects to meet new business requirements.
• Worked closely with Front End designers of various web applications in order to design and maintain new web pages.
• Build and maintain sql scripts, indexes and complex queries for data analysis.
• Troubleshoot for any database objects discrepancy and provide a solution for all environments.
• Query optimization and performance tuning of the stored procedure for smooth run of the web pages.
• Created ad hoc queries to on the basis of business requirement to create and analyze reports.
• Provide a support of production server if any issue is reported.
• Monitored the performances of stored procedures and created reference tables and indexes for the better performance of the application.
• Created and maintained the log of the database changes of all the development environments to avoid any discrepancy on application updates.
• Responsible for unit testing and retesting of the newly created stored procedures and functions in order to make sure it meets FRD (Function Required Documents) and BRD (Business Required Documents).

Environment: SQL Server 2012/2008R2, Windows Server 2008, Internet Information Server ( IIS) 6.0/7.0, MS-Access.

Confidential, Chicago, IL

MS BI Developer

Responsibilities:

• Using SSIS, Along with the LightSpeed server for the Recovery and the Backup of the Customer Data.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Implement migration SQL Server databases, DTS packages from one server to another.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Identified data issues and provided recommendations for resolution to ensure optimal performance
• Performance Tuning and optimization of the store procedure.
• Responsible for the Creation of the adhoc queries as per the Business requirement.
• Intensively involved in the setup and installation of the Development Server
• Involved in the migration and restoration of the TB data from the staging folder into the development server
• Rectified and fixes various bugs in the stored procedure as well as various suggestion of the outsourcing team is incorporated.
• Resolved various JIRA as per the business requirement.
• Monitored and provided front-line support of daily processes as well as in production server.

Environment: SQL Server 2008R2/2008/2005,SQL, Windows Server 2003, Internet Information Server ( IIS) 6.0/7.0, My SQL, MS-Access,LightSpeed.

Confidential, Louisville, KY

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in providing the structure, to store data and to maintain database efficiently, worked extensively in writing complex Queries and debugging complex stored procedures, Tables, Cursor, Views, Functions, Triggers and Indexes in the databases using T-SQL.
• Created stored procedures which compares the existing data in the database table to flat file data and loads the new data or updates the existing data in the tables provided by daily feeds in flat file.
• 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 to SQL server. Involved in creating the Batch Files to execute the SSIS packages with DTEXEC and scheduling the jobs using BI publisher/SQL Agent/Dollar Universe.
• Created the SSSI packages which look for current day file and process data to load into database tables on daily basis according to the client requirements.
• Creating SSIS package to load data fromFlat Fileto Flat File and Flat File to Data warehouse and Report-Data mart usingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created SSIS packages to extract the millions of records data (13GB) from flat files (comma delimited, fixed width), Access and oracle database and loaded into relational tables.
• Used various types of transformations such as Conditional Split, Derived Column, Data Conversion and OLEDB command, Merge, Union All to validating data and redirecting the data to insert and updating the data.
• Used the SSIS Script Task, Execute SQL Task, Foreachloop container, Data flow task in control flow to create the SSIS packages according to the client requirements
• Used foreachloop container to process multiple flat files according to naming convention and current date.
• Involved in Unit testing to ensure the correct functioning of the stored procedure and SSIS packages.
• Used staging tables, table variable and temporary tables to improve the performance.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Designed and built cube (SSAS) and MDX developing with 10 dimensions, in addition built partitions spanning 8 years by month.
• Experienced in writing MDX and designing DW schemas.
• Sophisticated process that built two Cubes, one for daily snapshot and other for comparing restructured data with current day hierarchies.
• Developed a Reference Cube to the daily snapshot cube in order to refer the old hierarchies with the current data. Made use of reference cube concept to improve the performance.
• Involved in creating different types of reports (Tabular Reports, Matrix, Cross Tabs, Drill Down, Charts, Functions and Maps) by extracting data from tables, store procedures into report builder and SQL server reporting services. And customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Developed reports using report builder 3.0 and SSRS and published as PDF, Excel, and CSV formats.
• Created reports which calls stored procedure; retrieves the data from database tables and displays data in the reports.
• Scheduled SSIS Packages, reports and stored procedures with SQL server agent, Windows batch file commands and Dollar Universe scheduling tool.
• Used various logging methods in SSIS packages to track the errors and generate the log files
• Scheduled the process in Dollar universe scheduling tool which executes the stored procedure and generates the flat file and sends it to control point with executing batch file FTP process.

Environment: SQL Server 2008R2, BIDS 2008R2, (SSIS) Integration Services, SSRS, Report Builder, T-SQL, MS Access, Oracle 10g.