SUMMARY:

• Over 7 years of in Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment. Business Intelligence / ETL and QA software testing experience on domains like Banking, Health Care & Clinical Trials, Ecommerce, Mobility, Telecommunication. Implementation & administration of Business intelligence and Microsoft SQL server 2014/2012/2008 R2/2008 in development writing complex queries, creating stored procedures, views.
• An enthusiastic and project - oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Excellent verbal and written communication, presentation skills and flexibility in adapting to a wide range of work environments by inculcating new relevant skills with ease in a time sensitive frame. A dedicated team player and goal-oriented professional with excellent organizational & interpersonal skills.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), Requirements gathering, Analysis, Design, Development, Implementation and Testing, Methods like Agile/Scrum, Waterfall, with emphasis on Software Quality Assurance including Functional and In-titration testing.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Expert in evaluating data models to design Tableau solutions and interactive data visualizations.
• Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Experienced in working with Business Intelligence (BI) team resolving technical issues, getting data models, ETL/Data model/reporting architectures and high-level designs.
• Experience in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries.
• Experience in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert and Merge Join.
• Expert in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases
• Conducted User Acceptance Testing (UAT) with users and stakeholders and prepared Standard Operating Procedures (SOP) documentation.
• Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
• Experienced in gathering, managing and documenting business and functional requirements and communicating effectively with Upper Management, Technical Teams and Quality Analysts.

WORK EXPERIENCE:

Confidential, Sacramento, CA

Sr BI Developer / ETL

Responsibilities:

• Developed the business logic and the design of data queries and calculations used to extract and format data for project reports and external presentations and Data Blending with multiple data source.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets, Actions and hierarchies etc.
• Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
• Develop reports for Call Center, Policy, Finance, Marketing, Plan Management divisions Realtime and historical reports, blending data from different data sources like SQL Server, Google Analytics and Oracle to create Dashboards. Transition of CUIC reports to Tableau.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Involved in Tableau installation and configuration with Single Server System and Three Node Server System.
• Configuring Users based on Active Directory and logged in through Run as User account.
• Maintaining SSL s for windows users and Mac Users. Working on Tableau User based Licensing and Core based licensing.
• Creating Users, User Groups and Projects through Tableau Server Web and assigned roles and permissions for Tableau Users.
• Created batch scripts for tableau Server backup atomization on weekly basis and save the backups folder.
• Using API extensions to schedule auto refresh live reports and defaulting date parameters etc.
• Maintaining Tableau data source connections and scheduled refreshes and updates.
• Involved in end to end implementation and enhancements on trading behavior data starting from requirement gathering and dashboards development in Tableau Desktop.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Developed Geo/Area Maps to show details on which states are most connected vs. the least states.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the market spread with Quick Filters for on demand needed information with just a click of a button.

BI (Tableau) /SQL Developer

Confidential, Roseville, CA

Responsibilities:

• Translating business requirements into visualizations and design documents.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
• Developed the business logic and the design of data queries and calculations used to extract and format data for project reports and external presentations.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Involved in Tableau installation and configuration with Single Server System and Three Node Server System.
• Configuring Users based on Active Directory and logged in through Run as User account.
• Maintaining SSL s for windows users and Mac Users.
• Working on Tableau User based Licensing and Core based licensing.
• Creating Users, User Groups and Projects through Tableau Server Web and assigned roles and permissions for Tableau Users.
• Created batch scripts for tableau Server backup atomization on weekly basis and save the backups folder.
• Maintaining Tableau data source connections and scheduled refreshes and updates.
• Involved in end to end implementation and enhancements on trading behavior data starting from requirement gathering and dashboards development in Tableau Desktop.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Developed Geo/Area Maps to show details on which states are most connected vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future trend of the financial performance.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the market spread with Quick Filters for on demand needed information with just a click of a button.

BI /SQL Developer

Confidential, Newark, Delaware

Responsibilities:

• Designed transformation rules and processes to derive the correct data from the extracted data and transform into the required format and structure to support the business requirements.
• Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Designed various schemas which are used for Landing the data, staging for transforming the data and PROD in MS SQL SERVER
• Extensively worked with Team Foundation Server.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
• Worked with different sources to extract the data like Flat File, Excel, OLE DB, and Raw File and loaded the data into different destinations like OLE DB, Flat File, Excel and Record Set Destination.
• Worked on multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all.
• Extensively worked with different control flow tasks such as Execute SQL Task, Data Flow, Execute Package, File System Task, Script Task, Send Mail Task and different containers like For Each Loop and Sequence Container.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Worked on migrating data from SQL Server 2008(R2) to 2012.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
• Created packages in SSIS with error handling. Worked with different methods of logging in SSIS.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in and support.
• Created drill through, drill down reports, parameterized reports. Deployed reports to Report server using SSRS

Junior Sql Developer

Confidential, Richmond, VA

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements
• Improved Performance by creating Clustered and Non- Clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Added more audits and alerts in SSIS Packages in case of package failure
• Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data in to the tables from Text files
• Managed index, statistics and optimize queries by using execution plan for tuning the database
• Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc. to clean data
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Deployed, tested and scheduled SSIS packages using SQL Agent
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports
• Deployed and scheduled Reports using SSRS to generate all reports including status