SUMMARY

• More than 9 years of professional experience in Business Analysis, System Analysis and development of applications using QlikView, SQL Server, DB2, Integration Services (SSIS),Analysis Services(SSAS) and Reporting Services (SSRS)
• Solid experience in creating powerful charts, graphs and dashboards dat convey meaningful data and insights using tools such as QlikView 11 and Google analytics
• Expertise in designing and optimizing the various T - SQL database objects like tables, views, stored procedures, user defined functions, cursors, indexes and triggers using Management Studio and SQL Profiler.
• Expert in interacting wif the customer, collecting business requirements, preparing business requirements documentation, developing test cases/plans, project management and use case modeling.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Expert in utilizing ETL tools including SQL Server Integration Services (SSIS) and ETL package design.
• Expert in designing and handling SQL Reports, Sub Reports and Drill down Reports and Crosstab reports using QlikView 11
• Proficient in designing report layout, sorting the data, defining subtotals for the reports using QlikView 11.
• Expertise in Microsoft Reporting Service (SSRS) wif Report Authoring, Report Management, Report formatting, Report distribution, Report delivery and Report security.
• Excellent understanding of full Software Development Life Cycle (SDLC)
• Worked in a plethora of industries like Financial Services, Health Care, Pharmaceuticals, Event Management, Insurance and Agriculture/Food & Nutrition
• Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema).
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
• Excellent communication and analytical skills

TECHNICAL SKILLS

Databases: Oracle 9i/10g, SQL Server 2005 / 2008 R2, DB2, MS Access 2007.

Programming Languages: C / C#, SQL, PL/SQL, T-SQL, Access/Excel VBA, XSLT, XSD, HTML, CSS, Python, Windows Batch/Shell Scripting.

Tools: /Methodologies: SQL Server Management Studio, SSAS 2008, Microsoft Office Suite 2007(Word, Access, PowerPoint, Outlook), Microsoft Project 2007, SQL *LOADER, Microsoft Visio 2007,Team Foundation Server 2010, Share Point 2010, Visual Studio 2010, TOAD for DB2,Google Analytics, JIRA, Basecamp, UML, VEDIT 6.2.

ETL: SSIS 2008, Pentaho Data Integration.

Reporting: QlikView 11, Tableau, SSRS

Operating Systems: Microsoft Windows Family, UNIX, Linux Ubuntu

PROFESSIONAL EXPERIENCE

Confidential, NY

QlikView Developer

Responsibilities:

• Responsible for the daily Extract, Transform and Load(ETL) of the EBCDIC data into the appropriate target databases based on the portfolio of the incoming data files
• Improved accuracy and speed of the entire ETL by developing automated Windows batch scripts dat decrypt/unzip the container files, perform operations on the individual files and finally load them into the target databases
• Analyzed files for loading issues and updated SQL load scripts to ensure proper loading.
• Update the process log for the client dashboard developed using QlikView 11 on a daily basis wif information about the files dat expected, received, loaded and reconciled for each day
• Developed end-to-end automation for data refreshes of account performance and application analysis of all bank portfolios using SSIS 2008. This resulted in savings of at least 40 hours saved per week per portfolio and also completely eliminated errors in the update process.
• Created an automated reporting system utilizing QlikView 11 tool to keep track of source tables, repository objects, records inserted/updated, portfolios and package run time on a daily basis and email the process log summary to the end users.
• Created Logical and physical Data models for SQL server 2008.
• Improved the performance of the SQL server queries usingquery plan, covering index,indexed viewsand by rebuilding and reorganizing the indexes.
• Created a report model on SSAS cubes
• Developed appropriate measures and dimensions for each bank portfolio using SSAS 2008 for deeper analysis
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.

Environment: QlikView 11, SQL Server 2008 R2, SSIS 2008, SSAS 2008, Batch Scripting, VEDIT, Windows 7.

Confidential, TX

QlikView Developer

Responsibilities:

• Interacted wif the customer and the systems analysts for the purpose of obtaining detailed and accurate business and functional reporting requirements
• Developed new reports and enhanced the existing reports using QlikView 11 tool based on the requirements for the Department of Agriculture as well as Food and Nutrition programs.
• Reviewed reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and the functional purpose of these reports
• Extracted existing data to manipulate/calculate/format into reports, charts, graphs and dashboards.
• Utilized QlikView 11 to extract/ transform data from source databases for clients based on requested time intervals

Environment: QlikView 11, SQL Server 2008, Oracle 11g.

Confidential

Senior Business Intelligence Analyst (QlikView)

Responsibilities:

• Interacted wif clients on a regular basis to discuss reporting and business requirements for each project
• Developed detailed project management plans in Microsoft Project for each event dat described the tasks, timelines and interdependencies between the various tasks in the report development life cycle
• Provided demonstrations and tutorials of the event management portal to clients
• Created Google widgets/charts using Google Analytics on the event management portal dat showed real time attendee metrics for each event
• Developed robust views, functions and stored procedures using SQL dat resulted in faster data retrieval from the database
• Created daily reports, as well as executive summaries by using QlikView 11, dat consisted of key event metrics so dat clients can use the data to plan for future events
• Created additional on-demand QlikView 11 reports examining session survey response rates, session attendance, survey comments and session attendance chart by demographics for clients
• Produced dashboards detailing portal/mobile usage, session survey analysis and the expo sessions activity using Tableau

Environment: QlikView 11, Tableau, Java/J2EE, DB2, Windows XP/7, Google Analytics, TOAD for DB2, DB2 SQL, TOAD Import/Export.

Confidential, MN

QlikView Consultant

Responsibilities:

• Created a 3 NF normalized data model using Visio 2007 for the mortgage data
• Acted as a point of contact between the technology and bankruptcy teams to ensure effective and accurate delivery of all bankruptcy reports.
• Created complex T-SQL stored procedures in SQL Server 2008 for generating a series of bankruptcy reports and data extracts for usage by the bankruptcy team.
• Developed robust T-SQL stored procedures, functions, triggers dat captured all the exceptions in the bankruptcy procedure data.
• Designed SSIS packages for the import/export of data between SQL Server and various data sources such as Access, Excel, text files
• Encapsulated the stored procedures for the bankruptcy reports and data extracts in SQL Server Agent jobs. Monitored all the nightly jobs on a daily basis by setting up email notifications, and fixed all the broken jobs.
• Utilized QlikView 11 reporting tool effectively for creating various reports such as simple, crosstab, sub reports, drill down etc. formats such as in PDF, Excel, and CSV.
• Developed robust master schema and forms for the Fees data Website using C# Winforms
• Expedited the fees data conversion process by means of developing an effective Excel VBA module dat copies all the relevant field values for fees data. Also developed an Access VBA module dat copies the cleaned up corporate advances data from the database as a new tab in the fees data source files corresponding to each account number

Environment: QlikView 11, SQL Server 2008 R2, SSIS/SSMS 2008, Share Point Server 2010, Team Foundation Server 2010, Windows XP/7, Access 2007, Excel 2007, Visio 2007,Visual Studio 2010.

Confidential, CT

Business Systems Analyst

Responsibilities:

• Interacted wif the customer and collected extremely detailed business requirements and created a robust business requirements documentation
• Responsible for the User Acceptance Testing(UAT) of a Java based staff scheduling application for the Healthcare Industry
• Created regular backups and restored MySQL and SQL Server client databases, logged issues in a bug tracking tool and communicated wif developers to make sure dat these defects were resolved
• Collaborated wif the QA team to prepare test cases and plans using established templates and guidelines in accordance wif in-house Quality Management Standards
• Conducted requirements feasibility analysis wif developers and developed design documents to conform wif customer requirements
• Ensured dat the latest releases of the application were tested thoroughly for quality before the deadline by means of effective organization and time management
• Created comprehensive system design documentation from scratch for the development of a robust electronic expense information system.
• Worked independently and developed highly effective flowcharts, workflow process diagrams, user screens, modules and reports for the electronic expense system.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.

Environment: SQL Server 2005/2008, DTS, SSIS/SSRS/SSAS/SSMS 2005/2008, Visio 2007, Windows XP/7, Access 2007, Excel 2007, Visio 2007, Oracle 10g.

Confidential, IL

Business Systems Analyst

Responsibilities:

• Responsible for writing & Editing Stored Procedures, Triggers, Views, Tables & T-SQL Scripts.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which TEMPhas resulted increase in performance of numerous modules.
• Created functions and developed procedures for implementing application functionality at the database side for performance improvement.
• Created datasets for reports using T-SQL and stored procedures for SSRS Reports
• Created Crosstab, Drill-down, Parameterized and Sub reports using RDL
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XML) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Environment: SQL Server 2000/2005, DTS, SSIS/SSRS/ SSMS 2005, Windows XP, Access 2003, Excel 2003.