SUMMARY

• Over 7+ years of extensive experience in database design, development with MS SQL Server versions 2012/2008/2008 R2/2005 using SSIS, SSAS, SSRS (BI Tools) in various domains such as Finance and Insurance.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, indexes, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Over 1+ years of experience inTableau Desktop in various versions of Tableau 8 and 9 versions.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau
• Expert in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from heterogeneous sources such as SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities(Data Warehouse, Data mart)
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Extensive experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, Dashboards using MS SQL Server Reporting Services (SSRS)
• Expertise in developing Parameterized, Chart, Graph, Linked, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Worked on all phases of data warehouse development life cycle, from gathering requirements to testing, implementation and support.
• Knowledge in dimensional modelling, SSAS, cube creation, cube partitioning, creating aggregations and deployment.
• Knowledge in creating data warehouses in both Kimball and Inmon methodologies.
• Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse (Star and snowflake schema).
• Experience in documentation of complex SSIS packages and complex Stored Procedures designed and built throughout the length of the project.
• Experience in various SQL Server tools such as Erwin data tools, red gate
• Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Security management, Notification and Trigger, Data Tier.
• Highly motivated professional with excellent communication, interpersonal skills and strong inclination to continuously learn new technologies.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection.

Data Visualization: Tableau, Microsoft Excel, SSRS

ETL Tools: SSIS.

Relational Databases: MS SQL Server 2005/2008/2012 , MS Access.

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio.

Languages: SQL, PL/SQL, C, Java HTML, XML, C#, .NET

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data, Windows 98/2000 XP, UNIX, LINUX.

Configuration Management Tools: Team Foundation Server.

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

SQL Server BI Developer

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
• Publish automated, interactive dashboards to end customers using Tableau.
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Defined best practices for Tableau report development.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Created Database objects like Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers
• Created required indexes to improve the performance of the queries
• Used SQL Server Integration Services (SSIS) to perform bulk insert operations from SQL Server 2008R2/2008 databases to flat files/CSV files and vice versa.
• Configure the SSIS Package for run time Parameters and Configured files as well as developing the Documents for Logging/Error Handling for SSIS Packages
• Performed job scheduling to ensure execution of certain jobs and daily updates.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Created XSLT files for loading the XML data to database.
• Implemented custom error handling in SSIS packages and also worked on different methods of logging.
• Created batch files to load the data from text file to database tables.
• Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.
• Performance tuning of SSIS packages.
• Created technical documents for the processof executing the packages.
• Involved in Project tracking using MS Project.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to the Share Point portal.
• Enhance/modify existing reports by creating new Parameters, Formulas etc,
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
• Developed complex SSIS packages to migrate the data from flat files to SSIS.
• Worked on source controls VSS (Visual Source Safe), Borland Star team.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, Tableau Software 8.0, MS PowerPoint, MS Project, MS Access 2003, Oracle, Business Objects, SharePoint, PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007,Borland StarTeam, Build Forge, Visual SourceSafe.

Confidential, Ohio, Columbus

BI Developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the legacy databases and SQL Server 2008 to SQL Server 2012.
• Create complex scripts to do chucking and massaging of legacy data in staging area of SSIS package.
• Drop and recreate Index on the DSS system while migrating data.
• Configure the SSIS Package for run time Parameters and Config file.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• SSIS used for extracting and merging of data from different sources to single source.
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
• Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Created pivot table to provide structured to Reports in proper manner like months etc.
• Wrote documentation for the packages and scripts and job created to migrate data.
• Created CSV and excel files for data analyst for the particular records they want.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• 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.
• Involved created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Participated in testing during the UAT (QA testing). Mentored and monitored team development and status.

Environment: SQL Server 2008/2012, SQL Server Integration Services, MS Excel 2007, MS Access 2007, Enterprise Manager, Management Studio, SQL Profiler and SSRS

Confidential

Software Engineer

Responsibilities:

• Creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Worked with MDX to query cube’s data.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented Complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed
• Various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, PPS, MS PowerPoint, MS Project, MS Access 2003, SharePoint, PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007.

Confidential

Software Programmer

Responsibilities:

• Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2005
• Extracted data from xml and flat files using SSIS
• Developed reports using crystal reports and used table control, matrix control for cross tab reports.
• Involved in designing of conceptual logical model and physical model
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
• Fine-tuned the logic in procedures, functions and triggers for optimum performance.
• Developed database triggers to enforce data integrity and additional referential integrity.
• Wrote transact SQL utilities to generate table insert and update statements
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks
• Used SQL profiler and query analyzer to optimize queries and stored procedures.
• Involved in performance tuning using indexing (cluster index, non-cluster index) tables.

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler and SSRS.