SUMMARY

• Over 7+ years of experience in IT industry covering Development, Analysis, Design, Testing and System Maintenance of Business Intelligence based applications and experience in Design and Development of Data warehouses and reporting layer
• Excellent communication skills, bridging Client Interaction and Team Management.
• Ability to quickly adapt to new environment and work with a wide variety of people at various levels.
• Good Understanding of SDLC and Relational Database Architectures.
• Articulate with excellent communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Having good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Experience in writing Dynamic SQL, SQL Stored Procedures, Functions, Packages, Cursors, Views, Database Triggers, Temporary tables, Roles and User defined data types.
• Expertise in database tools like SQL Server Management Studio, Enterprise Manager and SQL Server Business Intelligence Studio.
• Expert in report creation skills using Microsoft Reporting Services.
• Expertise in creating Dashboards and Status indicators using Reporting Services.
• Expertise in SQL Server 2008 R2/2008/2005 Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Integration Services (SSIS).
• Experience in designing Cubes, Facts, Dimensions and Data Mart of Data Warehouse.
• Experience in writing OLAP MDX (Multi Dimensional Query Language).
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages.
• Used Bulk Copy Program extensively for flat file import and export operation to/from SQL Server.
• Hands on experience with databases like MS SQL Server and Oracle.
• Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Intelligence Suite.
• Experience in performance tuning and optimization of BI repositories and solutions.
• Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling
• Expertise creating Executive dashboards for the upper management showing summary metrics for the Key performance Indicators (KPI’s).
• Used Tableau 8.2 to design reports, dashboards, storyboards for business users.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2008 R2/2012, Oracle 10g/9i/8 (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), Transact SQL, PL/SQL

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, Erwin Data Modeling Tool

Data warehouse: Microsoft SQL -SSAS, SSRS, SSIS, Tableau 8.2

Environment: MS Windows 95 - 2012, MS- Windows NT/XP, Unix.

Microsoft Technologies: MS Office Suite - MS Outlook, MS Excel, MS Power Point, MS Word, MS Access.

PROFESSIONAL EXPERIENCE

Confidential - Irving, TX

SQL Developer

Responsibilities:

• Worked with a team to gather requirements, design and build effective and practical solutions for the users.
• Analyzed requirements to build intuitive and user friendly solutions that enabled business users to run ad-hoc reports for quick data retrieval
• Created Data quality controls/checks that were run on the database to ensure the quality of data in building a data warehouse.
• Designed and developed data models for a data warehouse using Erwin Data Modeling Tool, and wrote SSIS packages to populate the data warehouse tables with logging
• Created metadata for user defined master tables to be referenced by application for user control, driven by business need.
• Designed and developed cubes for page tracking data to recognize patterns and trends of the usage and utilization of front end applications.
• Worked on profiling data, creating master dimensions after data cleansing for the data warehouse.
• Created Reports, Dashboards, Storyboards using Tableau 8.2. Create trend lines on charts, scatter plots, heat maps and other forms of representations.
• Provided business users with reports for daily reference to make business enhancing decisions.
• Worked on optimizing queries for better performance leveraging the use of clustered indexes and non clustered indexes.
• Used SQL Server Profiler trace files and Data tuning advisor to implement recommendations provided by the SQL Server engine.
• Utilized the estimated and actual execution plans to understand the bottle necks of sql queries and come up with better code.
• Used temp tables, table variables and common table expressions where necessary to write efficient queries.

Environment: SQL Server 2012¸ SQL Server 2008, R2, SSAS, SSRS, SSIS, Dts, BIDS, PL/SQLWindows SQL Server 2012, Windows SQL Server 2008, R2, Team Foundation Server, Erwin Data Modeling tool, Tableau 8.2.

Confidential - Plano, TX

SQL Developer

Responsibilities:

• Worked with the functional team on a regular basis for gathering requirements and attending meetings with upper management for collecting dashboard and reporting specifications.
• Involved in the end to end process of data warehousing, from creation of aggregation tables to ad-hoc reporting, along with dashboards.
• Comprehensive understanding of SQL server and the database schema and structure for better warehousing.
• Created the necessary data source views for the cube on the database for a good warehousing model.
• Worked with the database team in creating an effective repository model for reporting.
• Written necessary stored procedures and functions to populate certain necessary aggregation tables and scheduled these updates using the SQL Server Job Agent.
• Put performance optimization techniques in place to ensure better functionality of reports.
• Leveraged the use of indexed and primary key columns in the where clause of the reports to improve the performance of the query.
• Used estimated and actual execution plans to analyze and write efficient queries.
• Utilized SQL Profiler and Data Tuning Advisor to apply recommendations on the most frequently run queries.
• Leveraged the use of clustered indexes over non clustered indexes for faster retrieval times.
• Created schema bound indexed views where applicable to improve performance of queries.
• Created tables, views, stored procedures, user defined functions and triggers.
• Utilized CTE’s (Common table expressions), Temp tables and table variables where necessary for better performance of queries.
• Used commands like Rank and Row Number in profiling the data and coming with effective queries that suit business requirements.
• Used parameterized stored procedures in multiple scenarios as effective solutions to in corporate complex logic into queries that contain cursors, while loops, case statements, Dynamic SQL etc.
• Designed/Modified the reports as per the requirements adding calculated members over SSAS 2008.
• Uploading all the dashboards and the reports on the portal by creating ASPX pages using preset code templates and embedding them in portal that runs on Dot Net Nuke 6.1.
• Worked on phasing out the older technologies such as CDMA, and Decommissioning of Sites by creating analytical reports and ad-hoc reports based on cost effectiveness at the site level.
• Created various Market level reports with drop down lists providing the user with a wide range of selections based on user logins.
• Created drill through reports with various alerts. Created reports by restricting data depending on the role of the user.
• Designed dashboards at the network level giving the health/status of the snapshot of the entire system in a glimpse.
• Created maintenance/log reports for an overview of processes/events and their statuses (successes/failures)
• Added gauges/sliders, map features of 2008R2, geo spatial data for mapping and displaying different statuses of the network across the country.
• Worked on SSRS 2008 to generate about 100+ reports for various user groups and developer groups.
• Designed various parameterized reports that have functionalities like Drilldown, Drill through and also used features like toggle visibility based on the user selection.
• Utilized the caching and processing options by setting up schedules for the weekly and monthly reports on the report server, thereby optimizing the server resources and rendering time of the reports.
• Set up multiple reports as subscriptions using rectangles and subreports.
• Used indicators and data lines for trends in the market, along with sparklines.
• Designed SSIS packages for extracting data from data feeds in CSV file formats, and loading them on the database with the essential DDL and DML commands.
• Designed packages using SSIS to read and write to and from DBF files (Foxpro, dBase) into Sql Server.
• Cleansed data using multiple transformations such as merge, multicast, derived columns, data conversions, and conditional splits before loading.
• Used foreach loop containers to iterate through multiple files for SFTP/FTP and file system tasks for renaming/copying/moving files across directories.

Environment: SQL Server 2008, R2, SSAS, SSRS, SSIS, BIDS, Squirrel 3.2,1, PL/SQL, Windows SQL Server 2008, R2, Team Foundation Server, Visual Source Safe.

Confidential - Princeton, NJ

SQL Developer

Responsibilities:

• Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications.
• Worked on data from Heterogeneous Database (flat file data) to transform data to consistent data.
• Used BI content for developing appropriate data providers for business need.
• Performed tuning on existing reports for better performance.
• Scheduled the report by setting the run-time parameters and charted by customizing the options.
• Involved in the migration of Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing).
• Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Developed, implemented, deployed and processed cubes with dimensions and facts using SQL Server Analysis Services (SSAS).
• Used Multi Dimensional Query (MDX) language to slice and dice the cube.
• Created stored procedures both in SQL and MDX enabling linked server to use as the datasets for the Report Design.
• Extensively worked on Report coding to behave according to the front end Application.
• Wrote store procedures for Data Integrity.
• Involved in writing various DB Objects like Stored Procedures, User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Wrote SQL joins, sub queries, Table variables, Temp tables, Common Table Expressions (CTE) etc.

Environment: SQL Server 2008, SQL Server Management Studio, SQL Server Business Intelligence Studio, Team Foundation Server, SQL, T-SQL, Windows XP

Confidential - Denver, CO

SQL and SSRS Developer

Responsibilities:

• Worked on SSRS extensively to migrate reports from 2005 to 2008 for various user groups and developer groups.
• Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Created stored procedures both in SQL and MDX to use as the datasets for the Report Design.
• Developed Linked reports in SSRS.
• Worked on Perspectives in SSAS.
• Extensively worked on Report coding to behave according to the front end Application.
• Wrote store procedures for Data Integrity.
• Involved in writing various DB Objects like Stored Procedures, User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins
• Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS for better cube performance.
• Wrote SQL joins, sub queries, Table variables, Temp tables etc.
• Experience in Event Logging, error handling & logging Log files.

Environment: SQL Server 2008/2005, SQL Server Management Studio, SQL Server Business Intelligence Studio, Share Point, Team Foundation Server, VSS.

Confidential

SQL Server Developer

Responsibilities:

• Designed jobs to transfer data from the updated files and produce the latest reports.
• Developed cubes and using SSAS and developed few reports according the user requirement to display data.
• Worked on SSRS to generate reports to count the User IDs and Test IDs in different regions.
• Designed role based reports with click throughs and collapsible and expandable grouping.
• Also designed different kinds of reports such as tables, matrix, sub reports etc.
• Cleaned up the IDs which are not used from certain time.
• Created drill down and drill through reports for manager attestation reports.
• Created aggregation tables and views for efficient reporting.
• Designed database ‘following the Normalization rules.
• Wrote Stored Procedures in SQL Server.

Environment: Business SQL Server 2005, SQL Server Management Studio, SQL Server Business Intelligence Studio.

Confidential

SQL Server Developer

Responsibilities:

• Created DTS Packages, Stored procedures to populate tables and perform data manipulation tasks involved in the transformations to get the data in the right format.
• Used Import and Export Wizard, DTS Designer and other package execution utilities for performing the ETL operations.
• Created DTS packages to output SQL Data to various data sources for documentation purposes.
• Configured SQL mail agent for sending automatic emails when a DTS process fails or succeeds.
• Used Indexes to enhance the performance of individual queries and Stored Procedures.
• Created Stored Procedures to update the details of new consultants.
• Extensively created Stored Procedures using temporary tables minimizing cursors.
• Provided technical, user documentation and training.
• Created Views and User Defined Functions.

Environment: SQL server 2005, Windows 2000.