Data Sql Server
Resume:
Anu Sikharam
**************@*****.***
Summary:
• 7 years of experience in IT Software Development Life cycle involving Business
Requirement Analysis, Application Design, Data Modeling, Development, Testing and
Implementation of Data Warehousing and Database Business Systems
• Hands on years of extensive experience in the field of Data Warehousing, Data Architecture,
Data Modeling, Business Intelligence and reporting Applications (Qlikview).
• Extensive experience as QlikView Developer & Architect.
• Good knowledge in implementing and maintaining Dashboards and Scorecard Reports
• Strong working knowledge of Qlikview scripting, Set analysis, aggregation functions, multi-
dimensional objects and layout and design including chart properties and formats.
• Strong knowledge in basic components of QlikView Enterprise like List Boxes, Multi Boxes,
Tables, Charts, Current Selection Boxes, Buttons, Containers etc.. And experience in editing scripts
for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Experience in optimizing existing QlikView reports with a focus on usability, performance,
flexibility, testability, and standardization.
• Design of QlikView applications using QlikView Data (QVD) files, different Databases and
creating reusable variables.
• Trained the end users effectively to use the reporting tool (Qlikview), to build and customize
their ad-hoc reports.
• Used Qlikview publisher to schedule data load, distribute Qlikview application, and manage
security and access through Active Directory integration
• Having proven abilities in development, design, testing and production support for successful
execution of projects on Qlikview.
• Expert in database development skills using SQL and writing Stored Procedures,
Packages and Triggers.
• Ability to work in tight schedules with high quality and efficient in meeting deadlines.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL)
queries to perform back-end testing.
• Strong experience in understanding Business Applications, Business Dataflow and Data
relations. Exception ability to quickly master new concepts and capable of working in-
group as well as independently.
• Excellent communication, presentation and interpersonal skills.
Technical Skills:
Reporting Tools : QlikView 9.x, 10.x, 11.x series,
Languages : Visual Basic, Unix Shell scripting and SQL
Operating System : UNIX, Linux, WINDOWS NT/XP/7/2008 server
Software Development : Agile Methodology
BI Tools : Cognos10.X/8.4,(Framework Manager, Cognos Connection,
Report Studio, Query Studio, Analysis Studio, Power Play
Transformer,Business Insight, Metric Studio), Business
Objects 6.1, Actuate Reporting suite 10.0, VSS
ETL Tools : Informatics Power Center 7.x/6.x, SqlServer Integration
Services(SSIS), Abinitio 2.1
Qlikview Tools : QlikView BI, OBIEE, SSIS, SSRS, Informatica
Databases : DB2, Oracle 10g/9i/8i, MS SQL Server 2000, TOAD,
Excel and MS Access 2003. GreenPlum, Teradata.
Version Control : Motio, Share point, Visual source safe.
Education : B.Sc From Andhra University (May 2007)
First Data Corp/ Report/Dash Board /Omaha, NE Nov 2013 to till date
Environment and Development Tools: QlikView 11.0, Cognos BI 8.4/10.1.1, db2, TOAD4.5,
MS-excel, MS-Word, SharePoint
Responsible for design, development, delivery and Support of Credit Risk Management reports
and dash boards. These reports/dashboards were developed using IBM Cognos and QlikView.
Responsibilities:
• Understanding user requirements and expectations. Providing end to end reporting
solution.
• Involved in software evaluation for the Bank. Evaluated Tableau and QlikView.
Recommended QlikView
• Presentations and Training to different user community on dashboards
Build dashboards using QlikView. Implemented QlikView best practices. Designed data
•
model using database connection and excel files. Build multiple layers of QVDs, created
transformations, build hierarchies and so on.
Resolved synthetic keys in the model. Used various Load statements viz. Inline, Resident,
•
CrossTable and so on.
Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked
•
Graphs, containers and so on. Created links to access Cognos reports from the dashboard.
Created customer search. Used variables to show and hide objects based on user
selection.
Build Frame manager models/packages. Designed FM model in layers viz. database
•
layer, presentation layer, Adhoc Layer and so on. Created relationships, used shortcuts,
role playing dimensions and so on. Created standard filters in the FM model to be used in
all the reports. Designed reporting packages for report authors and Adhoc packages to be
used by end users in Query studio.
Build reports using Cognos package and native SQL. Created List reports, crosstab
•
reports, and reports with conditional formatting and so on. Published cubes to be used in
Analysis studio by end-users.
Developed dashboards using Cognos Business Insight.
•
Developing data extraction guidelines from multiple systems, data architect and data
•
modeling.
Building relationships with cross functional teams. Negotiations and interactions to
•
ensure quality and on time delivery of systems.
Responsible for managing user’s expectations, status communications to stakeholders.
•
Providing estimates, monitoring the development.
Performed UAT and successful production migrations and handover to production
•
support to close the projects.
WMS Gaming / Principal Consultant/FL Dec2012 – Oct 2013
Environment and Development Tools: Cognos 8 BI 8.4 (Framework Manager, Cognos
Connection, Report Studio, Query Studio, and Analysis Studio, Power Play Transformer),
Business Objects 6.5, Oracle 10g/Oracle ERP, JAROS. Qlikview 11, NPrinting, Microsoft SQL
server 2012, Windows Server 2008.
Responsibilities:
Work collaboratively with the business users and reporting teams
•
Optimized existing data models including changing load scripts to load data in optimized
•
way to achieve reduction of loading time.
Currently assigned to create dashboards by extracting data from multiple databases,
•
storing into QVD files, write load scripts, and develop UI according to user requirements.
simplifying complex expressions in the front-end, improving layout structure
•
Designed various Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other
•
sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts,
text objects, bookmarks, etc.
Design and deliver effective visualizations.
•
Build and maintain Qlikview applications.
•
Troubleshoot issues and find the effective solutions.
•
Worked on generating PDF, Word and PowerPoint Reports using NPrinting
•
Designed data models based on the client requirements and without any ambiguous or
•
Synthetic tables.
Stored the tables as QVDs and used Scripts to generate appropriate fields that help in
•
modeling the data according to the requirements.
Oversee the development of Qlikview applications
•
Define and maintain architecture and development standards for the Qlikview
•
environment
Maintain and execute the technology roadmap for the Qlikview environment
•
Effectively identify and remediate issues and risks that impact the
•
performance and reliability of the Qlikview solution.
•
Ensure consistency across applications as they are developed.
•
Ness Technologies/ QlikView Developer/ INDIA April 2012 – Nov 2012
Environment: Qlikview 11.0, SQL Server 2005/2008, TSQL,MS Access, Visual studio 10
BIDS,Teradata,Windows XP/2003 server, HTML, Excel
Responsibilities:
• Involved in business requirement gathering and development of functional and technical
specification documents.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline &
txt files in developing the QlikView Data Models.
• Connected to different ODBC, OLE DB data sources (SQL Server, MS Access, Oracle,
Teradata) and flat files to create and schedule different complex reports as per given business
requirement by leveraging the basic components of Qlikview.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping),
List, Input Field, Table Box and Calendar & Date Island.
• Developed KPI’s and set analysis applications.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the
Qlikview publisher.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous
relationships and closed loops.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input
Fields etc
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview
Publish and notified load status by email.
• Performance tuning by analyzing and comparing the turnaround times between SQL and
Qlikview.
• Optimizing existing data models including changing load scripts to load data in optimized way
to achieve reduction of loading time, simplifying complex expressions in the front-end,
improving layout structure.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better
performance.
• Build reusable macros to control Qlikview objects for ease of use by the users.
• Research and troubleshoot technical problems and Provided ongoing Qlikview consultation to
the development team.
Ness Technologies/ QlikView Developer / India Dec 2009 –March 2012
Environment: Qlikview 10/11, Oracle, SQL Server, TeraData, SAP, Excel, CSV files, Enterprise
Management Reporting Portal, DB2, Cognos, Informatica, QlikView Enterprise Server,
QlikView Developer, Autosys, Apache, Aajx, JavaScript, Flex, Flash, Java, ASP.NET, Agile
Scrum.
Responsibilities:
• Gathered, Analyzed, and transformed business requirements of the Client into logical
and physical BI solutions.
• Provided technical leadership in QlikView BI/DW design, dashboard and KPI metrics
design, data modeling, QlikView SAP integration, QlikView scripts development,
QlikView Set Analysis, and QlikView Server/Publisher setup/configuration.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Applied Scrum methodology in the system development process.
• Worked with cross functional team and business user to develop Business requirement
document(BRD), define key performance indicators(KPIs) and identify data sources.
• Conducted requirements gathering and developed strategy maps and roadmaps for
delivering Data Analytics and BI Reporting via QlikView in-memory technology
• Designed and developed QlikView software applications and server-based QlikView
dashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and
other issues.
• Designed and developed BI Reporting solution enabling users to effectively utilize the
tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align
KPIs performance metrics to strategic drivers and priorities.
• Identified data sources and targets for data modeling and solution architecture.
• Implemented new production methodologies that resulted in optimizing employee's time
to finish the tasks, thus enhancing employee efficiency.
• Created automatic schedulers to reload the data as per requirements.
• Developed predictive analytics and forecast models to help clients gain deeper insights
on existing data and information, improve business performance, and shape the future of
the companies.
• Worked closely with the development team to understand functionality, resolve issues
and provided feedback for the UML diagrams.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Provided ongoing QlikView consultation to the development team.
TCS/SQL Server Developer/INDIA June 2007– Dec 2009
Environment: SQL Server, SSIS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel,
C#, ASP .Net, ER Studio, performance point Server.
Responsibilities:
Filtered inaccurate data from legacy system using complex T-SQL statements, and
implemented various constraints and triggers for data consistency.
Worked on performance monitor counters for monitoring SQL Server environment.
Managed indexes, statistics and optimizing queries by using execution plan.
Analyzed business requirements and build logical and physical data models that describe
all the data and relationships between the data using Erwin.
Designed DTS Packages to transfer data between servers, load data into database, and
deploy the data, scheduled the jobs to do these tasks periodically.
Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data
into data warehouse.
Extracted the data from Flat Files, Transformed (Implemented required Business Logic)
and Loaded into the target Data warehouse using SSIS .
Prepared the complete data mapping for all the migrated jobs using SSIS.
Involved in Performance tuning of ETL transformations, data validations and stored
procedures.
Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
Involved in designing, developing and deploying reports in MS SQL Server environment
using SSRS in Business Intelligence Development Studio (BIDS).
Designed and developed various types of reports using SSRS and rendered them in front
end applications like Excel and .net.
Designed and created distributed reports in multiple formats such as Excel, PDF, XML,
HTML, .doc and CSV using SQL Server Reporting Services (SSRS).
Used MS Access for smaller databases to create the tables and generate the reports.
Created score cards with advanced set of dashboards using MS Office Performance Point
Server Dashboard Designer that feature executive summary measures.
Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
Resolved various performance issues by running DBCC command.
Performed daily tasks including backup and restore from disaster recovery by using SQL
Server tools like SQL Server Management Studio, SQL Server Profiler.
Contact this candidate