SUMMARY

• Strong experience in analyzing, developing and designing Server, Business Intelligence (BI) database applications using MS SQL Server and SQL Server Integration, Reporting & Analysis Services.
• Expertise in writing T - SQL queries, dynamic queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-Defined Functions, Views, Constraints (Primary key, Foreign key, Unique key, check key etc.) and cursors.
• Expertise in SQL, T-SQL, & Excel Pivot Table 2010/2013.
• Expertise in SQL, T-SQL tools including toad and SQL developer.
• Experience in reporting packages ( Crystal Reports).
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in SSIS, Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & SQL Server Analysis Service.
• Develop and run scheduled queries using SQL and T-SQL scripts.
• Develop Functional/Technical specifications for SQL Server Reporting Services reports.
• Hourly Basis Reports and Day wise reports Generation based on the user.
• Experience in creating various types of reports like Tabular report, Matrix report, Drill-Down/Drill through report, Cascaded parameterized, Chart reports, Sub reports, Ad-Hoc Reports and Cross Tab Reports using SQL Server Reporting Services (SSRS).
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio.
• Data warehouse Facts tables, dimension tables, implemented slowly changing dimensions with type0, type1, type2.
• Strong knowledge in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Good knowledge about big data technologies like Azure Data lake.

TECHNICAL SKILLS

Operating System: Server, Windows 7

Languages: SQL, T-SQL.

ETL Tools: SSIS (SQL Server Integration Services)

Reporting Tools: SSRS (SQL Server Reporting Services), Tableau, Sisense

Databases: SQL Server 2008R2/2012/2014, 2016

Database skills: Views, Cursors, Stored Procedures, Functions, Isolation levels, Joins T-SQL (Expert), SQL Server R2 (Expert), SSRS 2008 (Expert), SSIS (Intermediate)

PROFESSIONAL EXPERIENCE

Confidential - FortWorth, TX

BI Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data in to the tables from Text files, Excel file and CSV file.
• Worked on multiple projects simultaneously.
• Worked on Sisense Tool in developing dashboards for replacing the legacy SSRS reports.
• Created SSIS packages to load the data into the staging and the main tables along with archiving of the data into the history tables maintaining the back up of data.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute sql flow task, data flow task to extract data from different databases and flat files.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard.
• Involved in requirement gathering, analysis, design, development and deployment.
• Involved in creating Elastic Cubes and developing dashboards with various types of widgets.
• Pivot, Chart, Table, Tabber, Pie are various types of widgets used.

Confidential - Dallas, TX

SQL Server Developer

Responsibilities:

• Key role in requirement gathering and participated in all phases of the development life cycle. Worked in a disciplined and planned environment and followed Agile Scrum Methodology for application development.
• Created Tableau worksheet and dashboards involving Schema Import, Implementing the business logic by customization.
• Analyzed the functional and non functional requirements of the project and determined the environment necessary for smooth development.
• Determined the technical requirements of the project and came up with an architecture design. Played a key role in designing the database and created the required entities, attributes and relationships between database objects.
• Developed numerous SSAS Tabular Cubes to analyze Cloud Infrastructure, Application and Business Data with Visualization on Microsoft BI Platform.
• Develop, run and schedule queries using SQL and T-SQL scripts.
• Identified and defined Fact relationships in SSAS.
• Generate daily, and on demand reports.
• Monitor the overall reports availability.
• Experience in Microsoft Dynamics CRM Data integration towards import/export of data using SSIS and custom application development.
• Designed plug-ins to populate contact and account number on create of new record.
• Experience in RDBMS concepts, Physical and Logical Database design, table normalization, creating ER diagrams using Microsoft Visio.
• Performance tuning of long running queries by replacing cursors with various joins, common table expression (CTE)and indexing.
• Used multiple Tableau data sources (.tds) from excel, CSV, text files and RDBMS (SQL Server) as source systems for workbook generation using Import/Live connection and methodologies.
• Created project related modeling diagrams by using tools like Microsoft Visio and ERWIN. Installed and configured the SQL database on the database server as per project requirements. Created the database objects like tables, views, functions and triggers to ensure database consistency and orderly availability of data in required tables.
• Involved in configuring the web crawler to extract information from qualified website and push into the SQL database.
• Designed and created database objects for storing categorical information in various tables and defining relationships between them.
• Using Tableau Created dashboards with Combination Charts based on the customer requirement.
• Wrote complex procedures and queries to extract accurate information based on user request. Played a key role in designing the user interface of the application to support the project requirements.
• Participated in the weekly scrum meetings and ensured timely deliverables and releases. Involved in development of the application and deployed the application on to the web server. Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Prepared the application documentation with all modules functioning and necessary user manuals.
• Prepared various project related documents and gave presentations to the management team.

Environment: MS Access, VMware ESX, Windows 2000/2003, TSM, DTS, T-SQL, SSIS and SSRS, WAMP/LAMP Server, SQL Server 2012,SQL Database, HTML5, CSS 3.

Confidential - Atlanta, GA

SQL Server Developer

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and Confidential .
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Analyzed the existing data and performed the appropriate changes from SQL Server 2005 to SQL Server 2008 by following the Normalization standards to maintain data consistency and by performing data validation.
• Extensively worked on developing SSAS cubes, Aggregation, Data mining models and deploying and processing SSAS objects.
• Designed SSIS packages to load the data from SQL Server 2005 to the ETL tier. Transferred Flat files from different sources to the ETL tier by using BCP and SSIS Packages. Created SSIS Packages by using advance tools (i.e. pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
• Experience developing solutions with Microsoft Entity Framework.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy /exact lookups and String manipulations.
• Built Complex Formulas using "calculated-field" feature in Tableau for various business calculations.
• Developed complex reports with drop downs using MDX parallel period date range parameters for Week to Date, Month to Date, Quarter to Date, and Year to Date information.
• Enforced the Business Rules to filter bad data from system by using Complex T-SQL Statement, and implemented various Constraints and Triggers for Data Consistency.
• Created and scheduled Microsoft SQL Integration Services (SSIS) packages which monitors the jobs and sends the notification when the job fails.
• Designed SSAS cube based on DW data. Designed different hierarchy on time and geography dimension. Used parent child hierarchy on GL (general ledger) dimension.
• Standardized company reports by implementing SQL Server Reporting Services.
• Created different type of reports including: A Cross-tab, Conditional, Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status. Generated the various kinds of reports using Graphs and Images
• Develop Functional/Technical specifications for SQL Server Reporting Services reports.
• Developed complex SQL scripts for SQL database for creating BI layer on DW for Tableau reporting.
• Monitoring performance and optimizing SQL queries for maximum efficiency.
• Defined the sequence for the tables involved in import based on foreign key constraints. Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non Clustered Indexes for significant performance boost.
• Experience in working with TFS (Team Foundation Server) for Source Control.

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft SQL Server 2008 R2, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), XML, SQL Server Business Intelligence Development Studio.

Confidential

SQL Server Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and SQL joins.
• Developed complex T-SQL code for data retrieval.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Created and Modified Triggers and Dynamic Cursors in T-SQL for maintaining SQL server databases and assigned permissions to a role for Stored Procedures for Application Developers. Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Worked with SQL queries for data manipulations, Data extraction and Data Mapping. Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Worked on existing complex SQL Codes to fix the errors and change the procedures to match the requirements for various business reasons.
• Applying constraints and writing triggers to apply the business rules. Backing Up & Restoring User Databases.
• Created different type of reports including: A Cross-tab, Conditional, Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and SQL joins.
• Developed complex T-SQL code for data retrieval.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Created and Modified Triggers and Dynamic Cursors in T-SQL for maintaining SQL server databases and assigned permissions to a role for Stored Procedures for Application Developers. Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Worked with SQL queries for data manipulations, Data extraction and Data Mapping. Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Worked on existing complex SQL Codes to fix the errors and change the procedures to match the requirements for various business reasons.
• Applying constraints and writing triggers to apply the business rules. Backing Up & Restoring User Databases.

Environment: Windows 2003 Server, SQL Server 2008 R2, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler, Visual Source Safe, Windows XP.