We provide IT Staff Augmentation Services!

Sql Developer/ Bi Developer (ssis/ssrs/ssas) Resume

Camp Hill, PA

SQL Developer/ BI Developer (SSIS/SSRS/SSAS)

PROFESSIONAL SUMMARY

  • 7+ years of experience in Database Design, Development & Support of MS SQL Server 2012/2008/2005 /2000 in Production and Development.
  • Involved in business to develop Entity Relationship/data models, requirement documents, and ETL specifications .
  • Experience in all aspects of Data Warehousing (used Kimball’s approach) including project planning, requirement gathering, data modeling, development, deployment, maintenance and enhancement.
  • Experienced in migrating database system from SQL server 2005 to SQL server 2008.
  • Experienced in ETL design, development and implementation.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures
  • Proficient in working with SQL statements to extract data from data tables and verify the output data of the reports. Good at T-SQL, Sub queries, Correlated Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities.
  • Proficient in RDBMS concepts and Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors, CTE and Triggers.
  • Expert in designing and creating Indexes, planning and implementing Server Security and authentication.
  • Expert in T-SQL Programming, query optimization and performance tuning.
  • Experienced in using ETL tools to design SQL Server Integration Services (SSIS) packages in Business Intelligence Development Studio (BIDS) for Data Management applications.
  • Excellent experience in migrating DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2012 SSIS packages.
  • Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
  • Experience in error and event handling, precedence constraints, break point and logging.
  • Expert in using transformations like Aggregate, Multicast, Data conversion, Merge Join etc.
  • Involved in Data Modeling using Erwin 7.0/6.5 and Unified Modeling Language (UML) 2.5/2.0 tools.
  • Experienced in creating the MDX queries to access cubes and dimensions (SSAS).
  • Experienced with aggregation using OLAP analysis services cube.
  • Advance knowledge in RDBMS concepts, conceptual/logical/physical data models & Dimensional/Star/Snow Flake schemas.
  • Knowledge about MOLAP, ROLAP and HOLAP Proactive caching mode for cubes.
  • Experienced in SQL Server 2005 OLAP database development including KPIs, Data mining, slowly changing dimensions etc.
  • Developed reports on SSAS & SSRS on SQL Server (2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Developed Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Multi-valued parameters, Cascaded parameters, Linked reports, Ad hoc reports, Drill through, Drill down reports, etc. using SQL Server Reporting Services (SSRS).
  • Expert in Performance Tuning and Optimization of SQL Server.
  • Experienced in Deploying Reports in SharePoint solution builder and creating dashboards in SharePoint.
  • Excellent analytical and communication skills to present points precisely and solve problems efficiently.
  • Detail-oriented multi tasking with strong technical concepts and organizational abilities.

TECHNICAL SKILLS:

Operating Systems: MS DOS, Windows 9x/2000/NT/Server 2003/XP/Vista/7, UNIX 4.0

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, Oracle 8i/9i, 10g, 11g, MySQL Server 2012/2008/2005 ,MS Access 2000/2003/2007

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Analysis Tools: SQL Server Analysis Services(SSAS)

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Bulk Insert and BCP

Languages: Transact SQL (T-SQL), PL/SQL, C, C++, Java, C#, ASP.Net, VB Script,

DB Modeling Tools: MS Visio 2010, Rational Rose, Erwin 4.0,Visual Paradigm for UML

Reporting Tools: SQL Server Reporting Services (SSRS), Report Writing in SSRS, MS Excel

.Net Frameworks: .Net Framework 1.0/2.0/3.0/3.5 , Microsoft Office SharePoint Server (MOSS 2007)

PROFESSIONAL EXPERIENCE

Confidential, Camp hill, PA

MS SQL Server, SSIS, SSRS Developer

Description: In the United States, Confidential and its subsidiaries have 57,000 professionals with a single focus: serving the clients and helping them solve their toughest problems. They work in four key business areas — audit, financial advisory, tax and consulting but the real strength comes from combining the talents of those groups to address clients’ needs.

Responsibilities:

  • Working on access Health CT (CTHIX) Project which deals with health care data, used to get health care data from CT State.
  • Used to deal with Claims, providers, Recipients healthcare data, Program type, sub program type, Age groups, Premium Amounts etc.
  • Identified and defined multiple Datasets to generate sub reports based on main parameterized report.
  • Used matrix to group based on row & column to find appropriate values i.e. Total members in a particular program, particular sub program, age group, Gender etc.
  • Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters using SSRS.
  • Developed complex queries to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
  • Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS
  • Used report builder tool to create reports & to show the reports to end user.
  • Developed High level dashboards using SSRS.
  • Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
  • Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, sub-reports, charts, Pie charts, conditional and dynamic reports using SSRS 2012.
  • Generated drill down reports by passing parameters from top level to sub levels.
  • Involved with Query Optimization to increase the performance of the Report.
  • Developed Reports for business end users and used Report Builder with updating Statistics.
  • Uploaded reports on to the report manager and organized them in folders.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
  • Designed the reports layout for creating tabular and matrix reports.
  • Used prompts to generate Parameterized and Cascading Parameterized Reports allowing the user to limit the reports to particular cases and published the reports as PDF, Excel and CSV etc.
  • Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report and gave roles, user access with respect to security in Report Manager.
  • Used SQL server agent to schedule the reports.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Environment: MS SQL Server 2012, MS SQL Reporting Services, Business Intelligence development studio (BIDS), Report Builder 3.0, DB2, MS Excel and Windows 2007.

Confidential, Santa Clara, CA

MS SQL Server, SSIS Developer

Description: Confidential is an American multinational semiconductor chip maker corporation headquartered in Santa Clara, California. Intel is the world largest and highest valued semiconductor chip maker, based on revenue.

Responsibilities:

  • Extensively worked on stored procedures, views, Joins, tables, triggers, Cursors, Indexes, CTE, temp tables, table-valued, scalar functions etc. on various databases for critical data involving Demand forecasting, profit and loss, net revenue, etc.
  • Worked on creating dynamic queries to update/validate table values in multiple databases and servers.
  • Worked on Performance Tuning, Query Optimization and running Database Consistency Checks using DBCC Utilities.
  • Used profilers and index tuning wizards for performance improvement of data issues.
  • Used Date functions, String functions and Database functions to manipulate and format source data.
  • Functionality Testing and bug fixes /issue resolution during the various quality assurance testing cycles.
  • Extensively worked on debugging Stored Procedures and Triggers.
  • Worked on Table Partitioning to load current and historical data.
  • Reduced the T-SQL overhead successfully by avoiding unnecessary use of UNION, *, Top, Distinct and <> statements.
  • Configured SQL Server’s Optimal Settings (Locking & Memory) according to the usage of its tables, # of users and hardware.
  • Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
  • Created Triggers on tables having important data so that when changes done to that tables, the history of the changes are stored in Audit tables.
  • Worked on procedures involving automatic sending of emails to Application teams regarding RDMS build notifications when release is done weekly.
  • Worked on Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Multicast, Data conversion, Merge Join Conditional split, SQL task, Script task and Send Mail task etc.
  • Developed packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental / Historical load logic data from Source to Staging Environment and into the Enterprise Data Ware House.
  • Proposed KPI’s for trending infrastructure online performance, reliability and component failure events.
  • Experience in Error Handling using TRY and CATCH blocks and performance-tuning using counters in SSIS.
  • Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production) & schedule them to run on routine basis and monitor the error log for any errors.

Environment: MS SQL Server 2012, MS SQL Server Integration Services 2012, BIDS, T-SQL, Windows 2008 Server,VB.Net,Asp.Net.

Confidential, Columbus, OH

MS SQL Server, SSIS, SSRS and SSAS Developer

Description: Nationwide Financial is the financial strategies of nationwide bank, which do high-end web applications development for retirement plans savings, pensions and cash deposits, two-week iteration workflow.

Responsibilities:

  • Worked on insurance data involving data of customers. Used stored procedures, Joins, Views etc. to analyze the data.
  • Installed, upgraded and migrated databases from MS SQL Server 2008 to MS SQL Server 2012.
  • Developed logical database and converted into physical database using Erwin.
  • Proposed and implemented optimized side-by-side SQL server migrating plan with minimum server downtime.
  • Experienced in documenting the ETL process flow for better maintenance and analyzing the process flow.
  • Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month
  • Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2008.
  • Designed dashboard reports using SSRS in integration with SharePoint.
  • Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
  • Generated a report which identifies the performance efficiency of every component within the modules of payroll.
  • Implemented data views and control tools for guarantee data transformation using SSIS.
  • Extensively worked on data profiling task in SSIS.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Extensively worked on SCD transformation in SSIS package.
  • Successfully deployed SSIS packages with defined security.
  • Extensively worked with OLAP cubes to generate drill through reports in SSRS.
  • Wrote complex T-SQL queries and Stored Procedures for generating reports.
  • Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, sub-reports, charts, conditional and dynamic reports using SSRS 2008.
  • Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by using chart experts as per requirements.
  • Performed database maintenance using SSIS maintenance plan tasks.
  • Responsible to monitor performance and optimize SQL queries for maximum efficiency.
  • Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
  • Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries.
  • Implemented star schema in SSAS to develop OLAP cubes and generated ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2012.
  • Identified and defined Facts and Dimensions relationships for OLAP cubes in SSAS.
  • Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
  • Helped even as an administrator at times and good at troubleshooting like setting up drivers, installations of operating systems, assigning IP’s to machines, software issues, error-detections.

Environment: MS SQL Server 2012, MS SQL Server 2008 R2, MS SQL Server Reporting Service 2008 R2, SharePoint, MS SQL Server Integration Services 2008 R2, BIDS, T-SQL, Windows 2007 Server,VB.Net,Asp.Net.

Confidential, Boston, MA

MS SQL Server / SSRS /SSIS Developer

Description: Confidential is a management consulting firm that primarily serves public sector education, health, human services, and other state, county, and municipal government clients. Established in 1986 with headquarters in Boston, the firm has extensive experience in all 50 states, clients in six Canadian provinces, and a growing practice in the European Union.

Responsibilities:

  • Worked on health care data, used to get data from various states, creating extracts, ETL process.
  • Created and designed Staging, ODS (Operational data store), Normalized databases for various business needs.
  • Used to deal with Claims, providers, Recipients healthcare data and good at understanding health care business.
  • Implemented SQL server clustering to gain control over SQL Server uptime.
  • Created detailed reports for the employers to help them decide which retirement plan showing demographic information based on various parameters using SSRS 2005.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Scheduling jobs for nightly/weekly loads with efficient database backup and recovery plans.
  • Created several stored procedures to do bulk insertion, ftp of data/files from mainframe/host systems to SQL server
  • Monitored performance using SQL profiler and optimized SQL queries for maximum efficiency.
  • Identified and defined multiple Datasets to generate sub reports based on main parameterized report.
  • Developed data marts, cubes and ETL to process the cubes nightly, weekly and full refresh of data during the weekends
  • Developed and designed DTS package/application for importing the data from word and update
  • Created different user level groups, and assigned appropriate permission levels to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the Organizational hierarchy.
  • Generated drill down reports by passing parameters from top level to sub levels.
  • Uploaded reports on to the report manager and organized them in folders.
  • Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
  • Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes using Performance Monitor, Profiler, and Database Engine Tuning Advisor.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
  • Designed the reports layout for creating tabular and matrix reports.
  • Used prompts to generate Parameterized and Cascading Parameterized Reports allowing the user to limit the reports to particular cases.
  • Established data exchange and integration for XML documentation using XML schema.
  • Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report.
  • Analyzed OLAP cubes in order to generate performance reports, drill down reports.

Environment: MS SQL Server 2008 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2008, ASP.Net, MS Excel, Window 2007.

Confidential, Houston, TX

MS SQL Server, SSIS, SSRS and SSAS Developer

Description: Confidential is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. It maintains users checking and saving account information, allows users to make a payment, transfer funds and customize reports for users and bankers.

Responsibilities:

  • Involved in requirement gathering, analysis, design, development and deployment.
  • Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and T riggers.
  • Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used Batch Files to Import Data from other Data Base.
  • Carry out creation of SDLC documentation for existing applications.
  • Created packages in SSIS with error handling and worked with different methods of logging.
  • Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
  • Responsible for Import and export of data between the environments and Data Cleansing.
  • Responsible for migration of databases from old SQL server versions to SQL Server 2008.
  • Performed Data profiling tasks in SSIS Packages using the Data Profiler and standardizing the data appropriately for the database.
  • Experience in managing Alerts, Creating Jobs, and Operators through SQL Server Agent.
  • Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
  • Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
  • Developed various drill down, parameterized reports using Crystal Reports and SSRS 2008.
  • Created calculated measures for business calculations using complex MDX scripts.
  • Implemented hierarchies on Cubes, wrote MDX for creating calculated measures.
  • Responsible for creating OLAP cubes for deep through analysis using SSAS 2008.

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio(BIDS), SQL Server Profiler, XML, SSIS, SSAS, SSRS, ProClarity, Crystal Reports 10, Windows 2000/NT.

Confidential

MS SQL Developer

Description: The major goal of the project was to capture Slide Timings and transaction metrics for monitoring and evaluation purposes for 80 stores. The system utilized Sybase, SQL Server 2000/2005 and Power Builder.

Responsibilities:

  • Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
  • Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
  • Wrote complex queries, triggers and stored procedures, views and user defined functions.
  • Design and implement database logical and Physical Schemas.
  • Responsible for database tuning using normalization and application tuning.
  • Maintenance of Development, System test, Assemble test and Integration Servers and databases.
  • Query tuning, Index Tuning and performance tuning.
  • Creation and maintenance of databases, objects.
  • Users and user group creation and maintenance.
  • Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
  • Created custom and standard reports using Crystal Reports.
  • Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
  • Created and modified stored procedures to Create Reports.

Environment: SQL Server 2000/2005 Enterprise Edition, MS PowerPoint, MS Access 2000 & Windows 2K platform

Hire Now