SUMMARY

• Over 9+ years of IT experience as a SQL Server Developer and MSBI developer.
• Highly proficient in the use of SQL for developing complex stored procedures, triggers, user functions, user profiles, relational database models and data integrity, SQL joins and query writing
• Proficient in Performing data related projects such as analyzing and developing SQL scripts for clients, write/modify stored procedures and triggers using Microsoft SQL Server as a database platform.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects
• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2008/2012/2014 using SQL Server Integration Services (SSIS).
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
• Experience in populating the data warehouse tables using SQL*Loader, Oracle Packages, Stored procedures, Stored functions, Python.
• Interacted with Business Analyst, Operation Analyst, Project Managers, and Technical lead to gathering business and database requirements.
• Experienced in developing batch programs by using SQL, PL/SQL and shell scripts and in using SQL*Loader, TPUMP, FASTLOAD, and MULTILOAD for loading data from flat files into Oracle & Teradata tables.
• Excellent analytical and problem-solving abilities with good team management skills.
• Experiences in creating Shell Scripts for invoking SQL scripts and proficient with Unix commands.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Knowledge on AWS Architecture and services like Amazon EC2, S3, Redshift.
• Strong experience using Tableau Server, Tableau Desktop and Tableau Public.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Experience in developing data applications with Python in Linux/Windows and Teradata environments.
• Used Pandas python package to integrate data from multiple data sources and develop reports.

TECHNICAL SKILLS

Operating System: Windows XP/Vista/7/10, Unix.

Programming Languages: C, C++, ASP.Net, JAVA, Python, Unix Shell Scripting

RDBMS: MS SQL Server 2014/2012, Azure

Markup Languages: HTML, CSS, XML.

Databases: MS Access, Oracle 8/9i/10g, SQL Server 2005/2008/2012/2014 , Teradata.

Reporting Tools: SQL Reporting Services, Crystal Reports, Tableau, Power BI

Environment: Other Tools: MS-Office suite, BTEQ, AWS, Teradata V2R6/R12/R13 SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SQL Developer

Responsibilities:

• Involved in gathering requirements, analysis, and specifications from the clients.
• Built complex PL - SQLcodes for packages, stored procedures, and functions to support company's goals. Queries optimization to improve database performance.
• Created database maintenance planner jobs for performance tuning of SQL Server, which covers Database integrity checks and re-indexing.
• Maintained report to identify data migration issues and status.
• Wrote optimized SQL queries to pull required data for further reporting.
• To do Data matching - identifying, matching and merging records that correspond to the same entities from several databases or even within one database. Contributed as first-hand responder to data migration issues slack channels and platforms.
• Designed and developed Ad-hoc reports as per businessanalyst, operationanalyst, and project managerdatarequests.
• Writing complex SQL queries against data warehouse to check integrity, data profiling and data management.
• Performed Verification, Validation, and Transformations on the Input data before loading into target database.
• Designed and developed various analytical reports from multiple data sources using Tableau Desktop.
• Executed quality control checks in the form of SQLqueries to ensure dataintegrity and enforce business rules.
• Designed and developed weekly, monthly reports related to the HR partnership usingSQL.

Environment: Windows XP/07, MS SQL Server 2008 R2, SSRS, SSIS, SSAS, Business Intelligence StudioMS SQL Query Analyzer, SQL Profiler, MS excel, Visual Studio 2010, Team Foundation Server.

Confidential, Charlottesville, VA

SQL Developer

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Triggers to implement the business rules and transformations.
• Build analytics dashboards with Power BI Professional (including using DAX functionality) and handle automated, targeted communication channels for products and solutions from many sources. Create controls, filters, calculated columns and derived columns with while using DAX.
• Extensive experience in the development of Reports using Power BI and SQL Server 2014/2012 Reporting Services (SSRS) and Microsoft Access and developed Custom Reports and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi - dimensional objects.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Responsible for making sure reports are scheduled and delivered in a timely manner.
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Created ad Hoc and parameterized reports using SQL server 2012 reporting Services with data from SQL Server as data source.
• Scheduling reports using Reporting services to e-mail with an attachment in the desired format of report to the top management

Environment: Windows XP/07, MS SQL Server 2008 R2, SSRS, SSIS, SSAS, Business Intelligence StudioMS SQL Query Analyzer, SQL Profiler, MS excel, Visual Studio 2010, Team Foundation Server.

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Built a framework using UNIX and PYTHON to validate data migrated from TERADATA to SNOWFLAKE
• Managed report to identify load delays in daily updated production tables
• Maintained report to identify data issues
• Created, deployed and gave accessibility to databases on SQL servers
• Wrote optimized SQL queries to pull required data for further reporting
• Moving data between production systems and across multiple platforms like moving existing processes from TERADATA to SNOWFLAKE using PYTHON.
• Involved in spinning up EC2 instances and adherence to rehydration policies/maintenance
• Co-ordinated with off-shore Support teams to report data inconsistencies
• Good understanding and hands-on experience on PANDAS for DATA ANALYTICS, DATA QUALITY CONTROL, DATA VISUALIZATION.
• Performed data manipulations and data validations for build reporting structure
• Contributed as first-hand responder to data quality issues slack channels and platforms
• Designed and developed Ad-hoc reports as per businessanalyst, operationanalyst, and project managerdatarequests
• Designed and Developed various analytical reports from multiple data sources using Tableau Desktop
• Built a framework using Python to identify the load delays and recurring data issues between Snowflake and Teradata and automated to produce daily, weekly reports for support teams.
• Used VLOOKUP and pivot table functions in EXCEL
• Proficient working in loadingdatainto staging tables via views
• Designed and developed weekly, monthly reports related to the financial partnership usingTeradataSQL

Confidential, Fairfax, VA

Sr. SQL Developer

Responsibilities:

• Developed monitoring reports for several tests to make sure they perform accurately
• Using Python programs automated the process of combining data from multiple databases into one report by selecting primary keys from each database for data validation.
• Pulling monthly/weekly, daily reports using Dashboards.
• Developed and maintained the summarized data tables and created the Pivot tables using Excel.
• As part of the data migration from legacy SQL server to Teradata, Reconciled and validated the data between the two data sources.
• Utilized Pandas library in python to view the data in structured format for data analysis and reporting needs.
• Designed and implementedData IntegrationandETLprocesses withSSISpackages to make data available for reporting purpose within a data warehouse.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Used Pandas framework in Python for data alignment and data manipulation.
• Involved in designing cubes inSSASenvironment using Snowflake and Star Schemas.
• DevelopedUNIX Shell scriptsto automate repetitive database processes.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Extracted data from multiple data sources and created data extract files (TDE) for fast query execution in Tableau.
• Experience modifying views and dashboards in tableau to reflect updates and changes to requirements.

Environment: SQL Server 2014/2012 Enterprise Edition, TeradataV15, UNIX shell scripting, HTML, SSAS, SSRS, UNIX, Quality Center, Tableau, Python2.7.

Confidential

SQL Developer

Responsibilities:

• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP)environment for accessing and translating data into understandable and usable business information using SSAS.
• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS)andproduced ad-hoc, standard and create super user reports using(SSRS).
• Using SSAS created OLAPcubes for data mining and created reports from OLAP cubes using SSRS.
• Createdtabularandmatrix reportsinSSRS. Wrote stored procedures and functions to create SSRS reports.
• Involved in thecreation and deploymentof the reports usingSSRSand configuring the SQL Server Reporting Server
• CreatedSSISpackages for File Transfer from one location to the other using FTP task.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Using reporting services (SSRS) generated various reports.

Environment: SSAS, SSIS Packages, SQL profiler, ASP.net, VB Script, SQL Server 2012/2008 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, C#, .Net framework, XML

Confidential

Developer

Responsibilities:

• SQL scripts were developed for accessing data from the Oracle tables.
• Account base Impact analysis reports were generated using SQL as required by the client.
• Created reports using SQL, PL/SQL, and UNIX for daily and monthly payment reports.
• Experience in Extraction, transformation and loading of data using Oracle, MS Access from heterogeneous sources.
• Performed two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Experience in designing the procedures for getting the data from all systems to Data Warehousing system.
• The data was standardized to store various Business Units in tables. Daily Transactions were stored in History Tables for Analysis.
• Developed and customized Financial Reports and Queried from different database tables as per the requirement.
• Designed/Developed reports by using Micro Strategy (OLAP).
• Used SQL*LOADER to load data into Oracle application tables by (control files, data files).
• Creating SQL files indexes and calculated the table spaces for each table, tuning the SQL queries (based on plan tables). Grant and revoke table access to users.
• Good knowledge and experience in System Analysis, Business Process Modeling, Data modeling and Operational Support.
• Experience performing problem troubleshooting, problem resolution and root cause analysis for application and batch related issues.
• Assisted with the design and coding and implementation of new production and data storage systems.
• Provide 24 x 7 production supports on Application and database side.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.

Environment: Oracle 10g/11i, SQL, PL/SQL, SAS, MVS, MS Excel, MS Access, UNIX, WinNT/2K, Toad, Visual Basic, Micro Strategy.

Confidential

Developer

Responsibilities:

• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.
• Moved all strategy tables to production.
• Extracted data from existing data stores and performed ad-hoc queries.
• Run periodic reports such as partner report and student credit report for project managers.
• Utilized analytical and quantitative skills for mining data with the help of SQLPLUS
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Wrote in writing stored procedures and packages using PL/SQL.
• Developed stored procedures, Database level triggers using SQL and PL/SQL using Oracle 7.3.
• Responsible for the system study, analysis, design, development, coding, generation of reports using SQL, PL/SQL, MS Access, testing and documentation.
• Created control files to load data into databases by help of ETL tool (Extract Transform Load process).
• Assisted with the Design and coding and implementation of new production and data storage systems.
• Performed in-depth quantitative analysis or data analysis.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.

Environment: Oracle 8.0/7.3/10g, SQL, PL/SQL, MS Excel, MS Access, UNIX, WinNT/2K, Visual Basic, ASP, Micro Strategy