Sql Server Reports
Resume:
Athmaram P
*********@*******.***
Summary
●Over 13 years of IT Professional experience in Development, Client Analysis, Database Design and Presentation using SQL Server 2016/2012/2008r2 & Oracle 9i/10g.
●Strong knowledge of analysis, design, development, production, testing and implementation of applications in the Client/Server architecture using MS SQL Server and Oracle.
●Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications. Also worked with Agile methodology.
●Experienced working in domains like Healthcare, Pharmaceutical, Retail Banking, Mortgage, CRM, Government Services & ERP.
●Excellent knowledge of Normalization (OLTP) /De-Normalization (OLAP), Data Design methodology and build Referential Integrity across multiple tables.
●Experienced in T-SQL/PLSQL (DDL, DML) documentation, coding, programming and implementation of Business Intelligence solutions using SQL Server 2016/2012/2008r2 & Oracle 9i/10g.
●Experienced in writing SQL scripts to read/parse XML data.
●Monitored performance and Optimized SQL Queries for maximum efficiency.
●Experienced in creating SSIS packages using various data transformations like Conditional Split, LookUp, Merge, Merge Join, Derived Column, Script component and Data conversion.
●Experienced in interacting with Clients / Business users, to gather the requirements for BI solutions. Created various documents for functional and technical specs, organized discussions with the business/team regarding the proposed solution, migration strategy.
●Managed every level of development starting from analysis, UAT, moving to Production and Maintenance.
●Strong interpersonal skills, with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
●Capable of working as an individual as well as a part of team.
Technical Skills
Databases
Microsoft SQL Server 2016/2012/2008R2, Oracle 9i/10g & MS Access.
Reporting Tools
SQL Server Reporting Services 2012/2008R2 & Crystal Reports 10/XIR2/2008, Power BI
SQL Server
Management Studio, MS SQL Server Enterprise manager, SQL Integration Services (SSIS) and Analysis services (SSAS), BIDS/SSDT, SQL Profiler.
Operating systems
Windows, Linux
Tools
TOAD, SQL Navigator, ERwin, MS Visio, HTML, Team Foundation Server (TFS), SVN & Visual Source Safe (VSS), C#
Conduent Inc (Conduent Payment Integrity Solutions),
Chicago, IL May ’12 - Apr ‘18
Systems Development Principle
Responsibilities
●Designed Reporting (OLAP) database and created a reporting solutions for both Internal and External (client) users using MSBI tools. To help business users for generating various reports like Dashboards, KPI and many other transactional reports.
●I was responsible for all reports development/solutions using MSBI tools.
●As a part of our application redesign project I have designed a new DM (OLTP) for EDI module for processing and loading the data from various clients and various source formats.
●Lead the team of 8 people and guided them to create new ETL packages using a robust design. So if any new file formats or clients are added then with very minimal changes and short time frame it can be implemented.
●Created various stored procedures using Dynamic SQL for implementing client specific validations and bypass rules.
●As part of ETL package development, created packages to process claims transactions from various clients in various file formats.
●Used SQL Server Profiler to tune the performance of existing SQL objects like stored procedures, complex sql scripts etc. Created indexes to improve the performance of sql scripts.
●Created SSIS packages to read data from Informix DB (OLTP) and transform into reporting database (OLAP) on incremental basis.
●Interacted with end-users and business analysts to understand Business Requirements and transform them into Technical Specification Documents.
●Generated and managed reports / users on SSRS Report Manager.
●Created / Migrated over 150 reports for business on OLTP & OLAP modules using SSRS & Crystal Reports.
●Created various database objects like SQL queries, views, custom functions and stored procedures for reports distribution using SQL Server 2008R2 and later.
●Created reports with Dynamic and Cascading Prompts, drill down and drill through features.
●Trained users to learn how to use the new reporting solution using SSRS and created a training document for new users.
●During 2016 I have worked on POC for using Power BI reports to create more interactive dashboard reports for management.
Environment: SQL Server 2016/2012/2008R2, T-SQL, SSRS 2012/2008R2, Crystal Reports 2008, SSIS 2012/2008R2, BIDS/SSDT, TFS & Power BI.
Summit Energy,
Louisville, KY July ‘11- May ‘12
Sr. SQL Developer
Responsibilities
●Interacted with end-users and business analysts to understand Business Requirements and transform them into Technical Specification Documents.
●Lead/worked with offshore team, to create various DB (OLTP) Objects like stored procedures, UDFs for new web application development.
●Created various database objects like SQL queries, views, custom functions and stored procedures for application development & reports distribution using SQL Server 2008.
●Done troubleshooting, modification and performance tuning of existing SQL scripts.
●Designed SSRS reports using features like Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports as per standards for developing reports.
Environment: SQL Server 2008R2, T-SQL, SSRS 2008R2, SSIS (ETL), BIDS, Visual Studio .Net 2008, C#, SVN, ER-Model.
International Reading Association,
Newark, DE Aug ’09-July ‘11
Sr. DW Analyst
Responsibilities
●Created various database objects like SQL queries, views, custom functions and stored procedures for application development & reports distribution using SQL Server 2008.
●Created indexes to improve the performance and used SQL Profiler for identifying the various long running scripts and fine tuned the scripts.
●Developed SSIS packages to read/write (ETL) the Data from various sources for a DW (OLAP) design.
●Created various SSIS packages to Import & Export data for data extracts and transferring the data between multiple platforms.
●Troubleshooted, modification and performance tuning of existing SQL scripts for both application and reports.
●Designed Reports for Finance, Marketing, Inventory, Sales & Product Management modules by SSRS 2008R2.
●Converted the existing crystal reports RPTs to reporting services RDLs using SSRS.
●Developed reports using matrix, list and table formats. And used various custom formulae, grouping and conditional formatting reports.
Environment: SQL Server 2008R2, T-SQL, SSRS 2008R2, SSIS (ETL), BIDS, Visual Studio .Net 2008, C#, Crystal Reports XIR2 & TFS, MS Access 2008.
Indiana Child Welfare Information System (ICWIS),
State of Indiana, IN Jun ’08-Jul ’09
SQL Developer
Responsibilities
●Lead the team and involved with Client BA’s to gather the functional requirements & designed the process for reporting and SQL Development
●Designed & Created ETL packages using SSIS 2005 to transform data from Oracle, Excel, XML & Flat files to SQL Server for reporting purposes.
●Created various database objects like queries, views, custom functions and stored procedures for reports distribution & ETL process.
●Administrated the created Reports by assigning permission to the valid user for executing the reports.
●Involved in the reviewing / unit testing reports and document the results for various test cases.
Environment: SQL Server 2005, SQL Server Reporting Services 2005, T-SQL, Visual Studio .Net 2008, SSMS, SSIS 2005, SQL Profiler and Windows XP
Eli Lilly, Indianapolis, IN Aug ’07- Jun ‘08
Sr. BI Developer
Responsibilities
●Involved in multiple projects for Report Development using SSRS 2005 & Crystal Reports.
●Created reports using SSRS features like Table Format, Matrix Format, Graphs, Cascading Parameters, Sub Reports and Customized Text Formats.
●Involved in development of TSQL, PL/SQL scripts for reports distribution.
●Developed crystal reports using cross-tab, formulae, running totals, grouping and conditional formatting reports.
●Involved in creation of various complicated reports for generating the details of Case PR’s and Complaint PR’s.
●Developed various complicated reports for Trackwise application. For example: created a report for generating the Complaint Record Details used 24 subreports and 100’s of formulae and running totals with various grouping and selection expert filters.
●Used tools like SQL Developer and TOAD to develop PL/SQL scripts for reports distribution.
Environment: SSRS 2005, SQL Server 2005, TSQL, Crystal Reports XIR2, Business Objects XIR2, Oracle 10g, PL/SQL, InfoView, SSAS, C#, SQL Developer, TOAD, Track Wise, Remedy and Windows XP
Option One Mortgage Corporation, Irvine, CA Sep ‘06-Jul ‘07
Sr. BI Developer
Responsibilities
●Discussed with business analysts to understand Requirements and transform them into Technical Specification Documents.
●Developed various Service Management Reports using Crystal Reports, sub-reports, charts, parameterized reports and conditional reports.
●Using Charts, Formulas, Grouping, Adhoc Reports, Cross-tab Reports, Charts and Sub Reports.
●Developed the complex queries and used T-SQL cursors for reports data.
Environment: SQL Server 2005, C#, Crystal Reports 10, T-SQL, DTS (SSIS), SSAS, SSRS, MS Visio, Visual Studio.Net, Visual Source Safe, Remedy and Windows 2000
Iflex Solutions (Client: Canara Bank) Bangalore, India Feb ’06 - Sep ‘06
Reports & Database Developer
Responsibilities
●Designed and developed various reports using Crystal Reports.
●Created reports using various features of crystal reports like sub reports, cross tabs, formulae, running totals and groups.
●Developed various database objects like stored procedures, views and functions for reports distribution.
●Integrated reports to the FlexCube application.
●Performed performance tuning of PL/SQL queries for reports.
●Dropped and recreated the indexes on tables for performance improvements.
Environment: Oracle 9i, Crystal Reports 10; Crystal Reports API, XML, Visual Source Safe and Windows 2000
Venky’s India Ltd, Bangalore, India Apr ’05-Feb ‘06
Programmer
Responsibilities
●This was support role; I used to manage users for ERP application.
●Developing the front end screens using VB6, MS SQL Server and integrating the reports with it.
●Created and supported the database and forms developed using MS Access.
●Created online order application using ASP, Visual Basic 6.0, and JavaScript.
●Providing the support to the users on ERP and troubleshooting was done.
Environment: MS SQL Server, Crystal Reports8, Crystal Reports API, ASP, MS Access XP, VB6.0
Contact this candidate