We provide IT Staff Augmentation Services!

Sql Bi Veloper Ssis,ssrs,ssas /analyst Resume

DE

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, Crystal Info.
  • Was responsible for training business users on using Crystal Enterprise software.
  • Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
  • Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
  • Good understanding of Health care, and Retail domains.

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, DE

SQL BI Developer SSIS,SSRS,SSAS /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, BRD’s, Functional Specifications, Project task lists and plans
  • Worked with the Human Resources database.
  • 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 reports. 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)
  • 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.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • 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 trouble-shooting 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, Crystal Info.
  • Was responsible for training business users on using Crystal Enterprise software

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.
  • Defined the test scenarios (testing the bounds, validations) for the web application, identified and reported bugs to the development team.
  • Additionally performed bug fixes for the application, as part of the development team.
  • Developed and maintained checklists to ensure development was aligned with clients 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, Unx

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 time lines 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: Oracle, SQL, SQL Server, MS Access, MS Excel, Flat Files, Miscellaneous Data, CAD, CAM, Windows, Windows NT, Unix, Manual Testing, Third Party Tools

Hire Now