Data Sql Server

RAJESH GAMPALA

Phone: 248-***-****

E-mail: ****************@*****.***

CAREER SUMMARY

Business Intelligence Analyst/Developer with 13 years of experience in compilation, validation, manipulation, extraction, and reporting of information from transactional systems in organizations of all sizes.

Experienced in requirements gathering, functional specifications, and technical documentation as well hands-on development using VB, MS Access, Cognos, SQL Server and Microsoft technologies to design, develop, and deliver data warehouses/ data marts, reports, and dashboards to support strategic and operational objectives.

Recognized for a unique combination of business and technical expertise affording the ability to perform diverse tasks throughout the development life cycle.

Track record of excellent analytical and problem solving skills.

Proven ability to translate business problems into executable analyses.

A good understanding of statistics, including regression and predictive modeling.

Excellent communication skills to make recommendations and analysis to business users, both verbally and written

Experience using analytic software and BI (Business Intelligence) tools

Proficient in SQL and knowledgeable about relational databases.

Experience on automation, ETL, reporting, analytics, and using data and creative problem solving.

Validate and support data models, data-mining methodologies, and reporting of metrics.

Understanding of core Business Intelligence (BI)/data warehousing technology: RDBMS such as Netezza, SQL Server, Oracle. Fluency in data manipulation and analysis with Hadoop, or Hive.

Coordinate with domain experts to develop and refine data management best practices, policies, and procedures

Serve as a liaison between technology, operations, product management and the Data Analytics team.

Good time management skills with an ability to work on multiple concurrent projects.

General business metrics (familiarity with common model structures, analytic techniques, etc.). Familiarity with Salesforce/CRM and reporting systems strongly preferred.

Advanced SQL experience performing tasks like complex joins, temp tables, views, window functions, etc.

Business Intelligence development experience and programming experience

Working knowledge and experience in data design/dimensional data modeling

TECHNICAL SKILLS

Business Intelligence Tools: SSIS, SSAS, SSRS 2005/8/12, PPS, MOSS 2007, DTS, Excel Services, Tableau

Reporting Tools: Reporting Services, COGNOS, Crystal Reports, Easytrieve, Meditech NPR

Databases: MS SQL Server 2005, 2008, DB2, IMS, Access

Languages: Visual Basic 6, VBA, .NET, SQL, MDX, HTML/XML

Operating Systems: Windows XP, Windows NT, Windows 7, Linux

Methodologies: Agile, JAD, RUP, RAD, UML, PMI

Process/Modeling Tools: Microsoft Visio, Visual Studio, BIDS, Erwin

Office Tools: Word, Excel, PowerPoint, Access, Outlook, Project, Excel 2010

CRM Platforms: Salesforce.com/Veeva

EMR Platforms: Meditech

PROFESSIONAL EXPERIENCE:

Sr. Data Consultant, Kaiser Permanente Oct’ 07 – To Present

Collaborate with clinical users to gather business requirements for new data development tasks.

Analyze clinical work flow and application to identify related information extraction method in SQL data warehouse.

Data profiling to identify data issues and recommend ideas for resolution

Support and defend innovative solutions to stakeholders across business lines

Data preparation, validation and calibration of predictive models to improve business processes

Perform data analysis of the internal and external source data and develop and integrate algorithms and computational solutions to identify new solutions and maximize the model outcomes derived

Support implementation of models and methodologies to predict, quantify and/or forecast various operational and performance metrics

Analyze, exploit, and present insights to add value to Kaiser’s business processes.

Collaborate with quantitative and qualitative researchers and iterate quickly to generate usable insights for product and business decisions

Implement theoretically and practically sound solutions with end users in mind

Provide detailed analysis and documentation of methods, techniques, and findings

Collaborate with internal teams to facilitate technology led data management solutions for Business users.

Hands-on development in complex data extraction utilizing SSIS

Analyze clinical data structure between different systems to integrate data into a central data warehouse.

Develop complex reports and scheduled delivery processes utilizing SSRS and SQL jobs.

Produce ad-hoc SQL based reports in an on-demand environment.

Improve, reengineer and optimize legacy reports and data extractions.

Maintain healthy SQL Server performance tuning and resolve data specific issues.

Maintain existing and develop new ETL processes to facilitate healthcare data exchange between SQL data repository, datamart and other data sources.

Imported raw files in excel format in SAS and subsequently created SAS datasets and performed data manipulations on the datasets.

Cleaned existing data and converted them into useful SAS datasets, merged datasets and created reports based on Ad-hoc requirements.

Extensive use of PROC SQL to create subsets of data for further analysis.

Extensive use of DATA STEP, PROC MEANS, PROC SQL, MACROS, PROC FREQ, PROC TABULATE, PROC SUMMARY.

Used SAS – output delivery system ODS to format reports in HTML, PDF, XLS reports.

Developed various reports using Cognos to meet client needs.

Adept in using ODBC Connect to acquire data from EPIC Database and PeopleSoft.

Authored various SQL queries in PeopleSoft to generate reports to meet client specifications.

Developed and maintain CAP (Corrective Action Plan) application using MS Access for users to keep track of the status and also report to higher management.

Extensively used macros using VBA in excel.

Created various test cases and defects in QTP to keep track of user issues and solution on how the issue is resolved.

Participated in monthly releases to verify the defects were successfully implemented in PROD environment.

Technical skills: Congnos, Crystal Reports, EPIC, PeopleSoft, Visual Basic, MS Office, QTP, SAS (Data Sets, Macros, Proc SQL, ODS)

Senior Data Programmer/Analyst, Kmart/Sears Sep’ 06 – Sep’ 07

Supported existing Import 2000, Inventory Migration, validations using PL/SQL and Oracle Forms as per the user requirements.

Created various functions, procedures, and packages using PL/SQL.

Created various SQL reports for the clients to verify the data.

Created various shell scripts in UNIX for running different scripts.

Used SQL Loader to load files.

Used Utl_File to create files in SQL scripts.

Developed database applications in PL/SQL-Triggers, Packages, Functions, Procedures, Complex SQL.

Used Oracle Collection, Object Types knowledge and experience.

Worked on SQL Query tuning using different tools with a clear understanding of query plan.

Understand SDLC process and tools, agile program management concepts and version control.

Ensure data integrity and proper implementation of analytics tags

Help define and track KPIs for editorial, marketing and sales

Build dashboards for product management and sales teams, providing insights and drivers of metrics

Support sales process with data-driven insights, such as audience demographics and competitive analysis.

Track performance of consumer products and provide actionable insights to increase usage

Stay abreast of industry developments.

Technical skills: Oracle Forms, Oracle Reports, MS-Office, PL/SQL,

SQL Loader, UNIX, Shell scripts

Senior Data Analyst / Programmer, Star Cutter Dec’ 05 – Aug’ 06

Created and modified existing reports using Crystal Reports 8.5 for ERP application where users can run and report to various stakeholders and higher management.

Migrated Reports from Crystal 8.5 to Crystal XI.

Supported existing Tool Cutting application in Access and Visual Basic as per user requirements.

Worked on Unix/Linux environment with experience in Shell or Perl scripting.

Worked on ETL/ELT in Data Warehouse environment.

Design and Develop Metadata/Logical Data Models(RPD and Universe)

Technical skills: Visual Basic 6.0, MS-Access, MS-Word and Crystal Reports 8.0,

Oracle 9i, Crystal XI

Data Analyst/ Programmer, Budco Oct’ 01 – Dec’ 05

Developed and support various forms and Reports using Oracle for Financials, HR and Distribution modules based on user requirements.

Designed, developed and maintained various applications using Visual basic for users to look up data. Used ODBC to connect to Oracle and SQL Server.

Designed and Developed PDA Applications using AppForge for Camp Jeep and Ford100 Events which was used for the Ford centennial event to keep track of how many were attended

Created various custom forms in Outlook for users as to send a customized email to stake holders or higher management.

Written various shell scripts to extract data from file and also used SQL loader to load file. Used FTP to transfer file to client.

Involved in supporting existing PSP applications for Intranet application.

Technical skills: MS-Outlook 98/00/02,Visual Basic 6.0, Oracle Forms, Oracle

Reports, MS-Office, Crystal Reports 8.0, SQL Server,

AppForge 2.0, PL/SQL Server Pages, SQL Loader, UNIX, TOAD

EDUCATION & TRAINING:

•Bachelor of Science in Computers

•Data Warehouse Training in Troy, MI

STATUS: U.S. Citizen, willing to relocate.

REFERENCES: Available upon request

Contact this candidate