SUMMARY

• Over 8+ years of professional experience in the Information Technology field as a BI developer in MS SQL server 2014/2012/2008 R2 environment covering various domains.
• Excellent in writing T - SQL queries, creating clustered and non-clustered Index, working on DTS and Tear data, Data Cleansing, Data Migration and using them to alter and build objects.
• Excellent problem solving and analytical skills proficient in system-based decisions.
• Hands on experience in database normalization, de-normalization, optimization, Tuning, Back-up, migration, conversion and document processing using data modeling tools like MS VISIO 2010/2013.
• Proficient in creating dynamic packages for Incremental loads and data cleansing in data warehouse using SSIS.
• Experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Ability to build data marts and cube by analysis tool SSAS. Easy to build and deploy analytic solutions for decision support systems.
• Ability to measure, edit and compare business data with different queries. Good experience on KPI (Key Performance Indicators) areas.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures
• Experience in Application systems and understanding how the data resides in the source system to effectively create OLAP Structures to support reporting.
• Excellent experience in developing drill down, cascading, parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
• Experienced with visualization tools like Power BI, Tableau and SAP LUMIRA.
• Experienced in creating Ad hoc reports with complex design to query the database for Business Intelligence.
• Ability to assign different types of keys with their preferred data types.
• Experienced in installing, upgrading and configuring Microsoft SQL Server and Databases.
• Vast experience with SQL in understanding DDL, DML, DCL, TCL, DRL statements.
• Experienced in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Confident with operators, variables, wildcards, views, triggers in T-SQL.
• Clear cut idea about data warehouse, dimensional modeling, OLAP, OTAP, RDBMS and schemas.
• Good Understanding with AGILE methodologies like Scrum, Extreme Programming (XP) and Unified Process (USDP).
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

Databases: SQL Server 2017/ 2014/2012/2008

Languages: T-SQL, HTML, CSS, C#, Visual Studio 2017/2013/2012, SharePoint, Data Analyst (RDBMS, SQL)

O/S: Windows Server 2012/2003/XP/2000/NT/98/95, MS DOS 6.2

Reporting: SQL Server Reporting Services (SSRS), Tableau

Integration: SQL Server Integration Services (SSIS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor (DTA)

Internet Tools: Internet Information Server (IIS 5.0/6.0), FTP, TCP/IP

Other Tools: Microsoft Office 2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Senior SQL Server DWH/BI Developer

Responsibilities:

• Involved in Agile methodology by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems, completed work through Sprints.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Interacted with Business team to collect data for the conceptual design of the system.
• Coordinated with business users to understand business needs and expectations.
• Involved in requirement gathering, feasibility studies and organizing the software requirements.
• Involved in analysis and review of software and business requirement documents.
• Involved in defining the source to target data mappings, business rules and data definitions that are used as source by ETL developers.
• Created data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and validating them with data present in Source systems.
• Revisiting created Data Mapping documents in case of any Mappings or Transformation logic changes.
• Helped Data Architect by providing the artifacts that are needed to consider while designing the EDW.
• Conducted sessions and worked alongside with the Business analysts to create technical specifications and mappings for Business Data Glossary and reports.
• Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Generating Corporate Reports for Management Committee using SQL Server Reporting Services (SSRS) and Excel.
• Created tables using T-SQL queries to store the data and also creating database objects like functions, stored procedure, Clustered and Non-clustered Indexes using MS SQL Server.
• Experience in Data Analysis and Data Profiling using SQL and Excel on large volume of data sets like Teradata, Oracle, Flat files, SQL Server.
• Experience in creating data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and comparing them with source Data Profiling Results.

Environment: SQL Server 2008, T-SQL, SQL Server Management Studio, Visio, Excel Reports, Outlook, Service Center

Confidential, Raleigh, NC

BI Developer

Responsibilities:

• Responsible in maintaining databases.
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Performed intermediate queries using SQL, including Inner/Outer/Left Joins and Union/Intersect.
• Pulled data from existing customer databases using views built in SQL Server, Excel and csv flat files.
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Created Complex ETL Packages usingSSISto extract data from staging tables to partitioned tables with incremental load using Visual Studio.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Ensured processes and project plans implemented and used by the end user customers.
• Troubleshoot to resolve issues and meet company standards.
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.
• Provided regular reports for both internal and external stakeholders.
• Created cubes and data marts using SSAS
• Designed snowflake and star schemas for customer summaries.
• Used complex expressions to group data, filter and parameterize reports.
• Designed reports and visualizations using MS BI solutions utilizing MS SQL Server, SSAS, SSRS, Power Pivot, Power View, and integration with Excel
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.
• Created many complexes ad hoc reports like Tabular report, parameter report, drill through, and drill down reports in SSRS.
• Deployed and managed the reports in the Report Manager using SSRS 2008.
• Designed reports subscription schedule for managers.
• Standardized reporting formats and statistical analysis methodologies.
• Visualized nationwide growth with Power Map.
• Used Power query and Power view extensively for mobile data improvements.
• Created predictive models and verified predictive analytics for the business solutions using Rapid Miner.

Environment: SQL Server Data Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Management Studio 2012, Power BI, Rapid Miner.

Confidential - Long Beach, CA

SQL/SSRS Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification
• Developed database objects like tables, views, stored procedures in SQL Server 2008
• Created Partition Tables based upon Partition Functions and Partition Schemas
• Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.
• Created reports based on the format specified in the design document
• Documentation of all the processes involved in maintaining the database for future reference
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS
• Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Created stored procedures to build the Fact tables in the data mart for multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS
• Created reports using SQL Server reporting services (SSRS), which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various administrative tasks
• Involved in Unit Testing, Integration and deployment in Production and Staging Servers.
• Data migration (import & export - BCP) from Text to SQL Server

Environment: MS SQL Server 2005/2008/2008 R2/2012, Visual Studio 2005/2008, C#, MySQL, Windows 2003/8, Windows XP, T-SQL, ASP.NET, Visual SourceSafe, TFS, JIRA, XML, ER Studio, SSAS, SSRS, ERWIN, Power Pivot, Power View.