PROFESSIONAL SUMMARY:

• Highly motivated SQL server Developer with over Ten Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005, SSIS and SSRS.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/2008/2005 /2000.
• Experienced in client requirement Analysis, design, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/2008/2005 /2000, SSIS, SSAS and SSRS 2005/2008/2012.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts and Batches.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Worked Extensively on ETL process using SSIS package.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.
• Expert in Translating Business needs into end-user Reports using Crystal Enterprise Suite XI/ 10.0/9.0/8.5/8.0, Seagate Info, and Crystal Info.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Good understanding of Health care, and Retail domains.
• Member of PASS - Professional Association for SQL Server - Microsoft Data Platform
• Member of TDWI - The Data Warehousing Institute
• Member of DAMA - Data Management Association.

TECHNICAL SKILLS:

• SQL Server 2012/2008/2005 /2000
• MS-Access
• OLE-DB
• SSAS and OLAP
• Transact SQL
• VB.Net
• ASP.Net
• C/C++
• SQL Enterprise Manager
• Query Analyzer
• SQL Server Management Studio
• SQL Server Integration Services (SSIS)
• Import Export Data
• SQL Server Reporting Services (SSRS)
• Microsoft Excel
• Windows 95/ 98/NT/2000/XP/Vista
• UNIX
• LINUX
• MS DOS
• MVS. Business Objects/Crystal Enterprise 10/XI
• Crystal Reports 6.5/7.0/8.0/9.0/10.0/ XI

PROFESSIONAL EXPERIENCE:

Confidential, VA

Data Developer

Responsibilities include:

• Performed complex financial data analysis to research issues, document data derivation and data movement requirements.
• Develop key project artifacts such as project scope, business requirements, risk and controls assessment, issues and risks, user acceptance testing, documentation, and SOX testing.
• Support the team in multiple projects ensuring adherence to Methodology, Controls and Quality Standards.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Manage production application support duties which involve on-call support for troubleshooting critical data and system issues of supported applications, logging issues, working with IT to determine root cause.
• Actively participated in User Acceptance Testing, and debugging of the system
• Developed Store procedure and Triggers in T-SQL
• Proficiency with advanced SQL, Access, and Python.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Supported development effort by providing T-SQL statement tuning and optimize data loading processes.
• Expertise in querying, analyzing, reconciling and testing complex relational data.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Planning and executing data conversion, data mapping and data reconciliation activities
• Strong attention to details with proven analytical and problem-solving skills.
• Ability to use data to help inform strategy and direction.
• Continuously strived to improve work processes rather than accepting the status quo

Environment: SQL Server 2012/2017, Reporting Services (SSRS),T-SQL, Windows Family, Tableau (Desktop/Server), Azure, Java, .NET, C#, XML, JavaScript, VBScript, PYTHON, SSIS, Microsoft office Suite (Word, Excel, Access, PowerPoint)

Confidential, DE

SQL BI Developer/Analyst

Responsibilities:

• Participate in all phases for building a Data Warehouse for analysis, requirement gathering, Design and Development of code.
• Created and Presented Agenda’s, confidential’s, Functional Specifications, Project task lists and plans.
• Developed SQL Server and MS Access databases for various usages.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Extensively used SSIS to move data from text files to SQL Server.
• Views using T-SQL in Development and Production environment for SQL Server.
• Created Quality Assurance stats reports using SSRS
• Extensively involved in SSAS cube creation, storage and partitions, and Aggregations, calculation of queries with MDX.
• Created SSIS packages for new projects utilizing Business Intelligence Development.
• Writing complex Stored Procedures to meet the business requirements.
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created data sources, connection strings and defined the datasets for generating the report.
• Worked on all types of report types like tables, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed, monitored and deployed SSIS packages.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler.
• Created subscriptions to provide a daily basis report. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Extensively involved in SSAS cube creation, storage and partitions, and Aggregations, calculation of queries with MDX.
• Developed reports and dashboards in Power BI.
• Migrated existing self-service reports and ad-hoc reports to Power BI.
• Developed audit scripts for integrity check and reconciliations
• Performed unit testing, system integration testing, UAT, stress test and operational readiness test.
• Performed root cause analysis for the issues raised and fixed them
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.

Environment: SQL Server 2012/2017, Reporting Services (SSRS), T-SQL, Windows Family, Tableau (Desktop/Server), .NET, C#, XML, JavaScript, VBScript, PYTHON, SSIS, Microsoft office Suite (Word, Excel, Access, PowerPoint)

Confidential, Herndon, VA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the application
• Developed Physical data models and created DML scripts to create database schema and database objects
• Performed Debugging on the Stored procedures for the requirement to handle the errors
• Employed Transparent Data Encryption, a new feature of SQL Server 2008 to store the data securely by encrypting the database files.
• Development of custom scripts and stored procedures for data import and manipulation
• Implemented Full Text Search for fast and efficient querying when large and unstructured data is encountered.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Server databases using SQL Server Integration Services (SSIS ) to overcome transformation constraints.
• Implemented Incremental load, used Event Handlers to clean the data from different data sources
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS ).
• Extensive knowledge on Business analysis and Business Intelligence.
• Enterprise Reporting solutions delivery using Crystal Reports, Crystal Enterprise/Seagate Info, Seagate Analysis.
• Developed Reports for business end users using Report Builder and Power BI with updating Statistics.
• Developed Power BI reports using query logic based on business rules, and visuals selected by stakeholders
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports .
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005
• Interacting with the Database Administrator to maintain the database used DBCC Statements to perform maintenance tasks before backing up the databases.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema

Environment: SQL Server 2000/2005/2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, C#, .Net, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, MS Access, MS visual Studio, BIDS. BI Reporting Tools: Power BI, Tableau and MicroStrategy.

Confidential, Allen, TX

SQL Server SSIS/SSRS Developer

Responsibilities:

• Played an active role during the requirements gathering, analyzing and designing of the system.
• Created logical data model using ER/Win 4.0.
• Development of large-scale test databases and associated maintenance scripts.
• Development of custom scripts and stored procedures for data import and manipulation
• Configuring, tuning, and optimizing SQL Server 2005.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery .
• Created horizontal partitioning of data for different file groups.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS .
• Production support, troubleshooting and debugging in a high volume transaction processing environment utilizing a lot of XML .
• Configured and trained users to use Reporting Services.
• Create parameterized Reports using Charts, Cross-Tab and Sub-report types.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).

Environment: Windows 95/NT/2000/2003, Microsoft SQL Server 2000, Microsoft Excel, ODBC, XML, SQL Query Analyzer, DTS, Erwin, Visual Source Safe, Reporting Services (SSRS), BIDS.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases
• Daily, weekly, and monthly production data processing, monitoring, and troubleshooting in an environment of operational systems
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Wrote stored procedures for report generation in SQL Server2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Created and Maintained Database Maintenance Plans .
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting
• Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production.
• Maintain disaster recovery strategies for the database and failover methods.
• Translated Business needs into end-user Reports using Crystal Enterprise Suite 10.0/9.0/8.5/8.0, Seagate Info, and Crystal Info.

Environment: SQL Server 2000/2005, Windows Server 2003, Windows NT, .NET, DTS, BIDS, Crystal Reports.

Confidential

SQL Server/Data & QA Analyst

Responsibilities:

• Conducted functionality, usability, interface, compatibility and security testing of the web application developer.
• Additionally, performed bug fixes for the application, as part of the development team.
• Developed and maintained checklists to ensure development was aligned with client’s specifications and requirements.
• Maintain medical records.
• Worked on various billing and coding procedures.
• Assisted in preparing user stories in the product backlog after the collection of functional requirements from system users and prioritized the requirements in product backlog.
• Provided support to QA team.
• Creation and Execution of the Functional Test Cases.
• Responsibilities of site feasibility assessment for business, improvements on site draw backs, and focus on new techniques for low CAPEX and maintenance. His major contribution was on systems setup, QA/QC processes, data warehouse management which enabled smooth transition of various tasks with zero snags. Also involved in Vendor Management.
• Managed all surveillance projects as per contract documents and ensured compliance to all requirements.
• Prepared reports for all Projects and Warehouse in/out Transactions of all business units across India.

Environment: SQL Server 2000/2005, SQL, Oracle, Windows Server 2003, Windows NT, .NET, DTS, BIDS, QTP, WinRunner, LoadRunner, Unix.

Confidential

Data Analyst, Quality Analyst, Support Engineer, Eng. Intern

Responsibilities:

• Used various types of date for Site selection for prospective business.
• Provided IT CAD, CAM designs for development with concern Architects and Engineers.
• Administered and performed various certified civil engineering database activities.
• Documented project activities for all new construction projects using MS Office
• Assisted in renovation and recommend improvements to all real property data.
• Assisted in various new construction projects and recommend changes.
• Managed all procurements as per required timelines and ensured compliance to all requirements.
• Managed the sales data of space commercial and Residential proceeds
• Developed all cost estimates for projects and utilized various estimate tools for all projects.
• Complete the project in stipulated time and cost with approved standards
• Involved in Manual testing in all phases of the project.

Environment: MS Access, MS Excel, Flat Files, Miscellaneous Data, CAD, CAM, Windows, Windows NT, Manual Testing, Third Party Tools.