SUMMARY

• Five years of IT analyzing data, database development on SQL Server and creating process for deploying, upgrading, managing, archiving and extracting data for reporting.
• Hands on experience with scripting in T - SQL/PL-SQL (DDL, DML) statements, stored procedures used to retrieve and modify data from the database.
• Hands on experience with Report development using SQL Server Reporting Services (SSRS).
• Experience in Data Extraction, Transforming and Loading (ETL) between various sources and targets using SQL tools (SSIS, DTS, Bulk Insert, BCP).
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages in SQL Server Agent.
• Experience in designing, creating, processing of cubes using SSAS
• Excellent hands on experience in creating groups and measures, KPIs.
• Good knowledge in using Microsoft Excel, PowerPoint, Word, Visio, Erwin Data Modeler.
• Good documentation skills, excellent communication, and interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS

Query Languages: T-SQL, MDX, PL/SQL

RDBMS: MS SQL Server 2000/2005/2008 , MS Access, Oracle 7.3/8/8i/10g/11g

Integrated Development Environment Tools: Visual Studio 2003/2005/2008

Reporting Tools: SSRS, PerformancePoint 2010 Dashboard Designer, Clarity 7.2, Business Objects, Crystal reports, Brio, Cognos, Power Pivot

ETL: Informatica8,SSIS

Packages: MS Office 2003/2007, MS FrontPage, Adobe Photoshop, Flash, Dream Weaver

Web Technologies: HTML, CSS, XML, Java Script, VB Script

PROFESSIONAL EXPERIENCE

BI Developer

Confidential, Dallas TX

Environment: SQL Server 2008, SQL Server Reporting Services (SSRS), SQL Server Integration services (SSIS), SQL Server Analysis Services (SSAS), Oracle 10g/11g, Toad, Microsoft Dynamics AX, T-SQL,MDX Query, PL/SQL, VB Script, MS Office Performance Point Server 2010 Dashboard Designer, IBM Clarity 7.2, Power Pivot, MS Access, MS Excel, Information Builder Web Focus 8.0, Microsoft service manager 2010

Responsibilities:

• Create Stored Procedure in TSQL/PL-SQL, triggers, user defined functions, SQL joins, query writing and did Performance Tuning.
• Created SSIS packages using control flow and data flow tasks and transformations for the AX data ware housing project.
• Used Business Intelligence Development Studio (SSRS) to develop parameterized drill down reports from SQL Server 2008 OLTP and OLAP data sources with T-SQL and MDX queries and from Oracle OLTP data sources with PL/SQL in Agile development methodology.
• Managed all business user requests/tickets using Microsoft Service Manager 2010 for all report development for the Circulation systems including SSRS reports and one time query data requests.
• Followed report development standards for new requests and applied standards to existing reports.
• Maintained excellent relationships with our business unit customers.
• Worked through all requests with little to no managerial supervision.
• Supported requests from requirements, throughout development, quality and user acceptance testing and implementation into production.
• Created report models in Business Intelligence Development Studio and deployed to the report server.
• Created and configured data source & data source views, dimensions, cubes, measures, partitions, KPI’s & MDX queries on development server using SQL Server 2008 Analysis Services for Microsoft Dynamics AX.
• Created prototype dashboards using MS Office Performance Point Server 2010 Dashboard Designer by extracting data from a SQL Server 2008 OLAP development data source and deployed them to development SharePoint sites for Microsoft Dynamics AX.
• Created and tested Oracle PL/SQL procedures and functions in PL/SQL packages using Toad in Circulation databases.
• Created Universe’s and reports using Dynamic Report Writer (an Operational reporting tool in the Circulation system) and scheduled the reports using report scheduler.
• Created planning and projection HR and Budget Reports/Templates using Clarity 7.2.
• Used SQL Server profiler to capture the errors and modified MDX queries for Clarity reports.
• Extensively used excel formulas and functions to manipulate the data.
• Took training to develop adhoc reports, dashboards and scorecards using Information Builders web focus 8.0.
• Involved in all phases of Software Development Life Cycle (SDLC) including Analysis, Design, Development, Testing, Implementation and Maintenance.
• Exposure to Team Foundation Server for source control, source repository and project tracking solution.

Graduate Assistant

Confidential

Environment: SQL Server 2005, Windows XP, Active Directory, MS Access, MS Excel, SQL Server Reporting Services (SSRS), Visual Studio 2005, ASP.NET

Responsibilities:

• Worked as a database developer for the office of foreign languages.
• Involved in installation of software and hardware required for website and database administration.
• Responsible for foreign language website and database maintenance and troubleshooting issues.
• Used DML T-SQL commands and stored procedures to query the student database.
• Backing up the foreign language student database.
• Designed student attendance/performance reports using the Report designer.
• Performed V-Lookups and conditional statements in Microsoft Excel.
• Prepared and maintained the documentation using Microsoft Word.

Data Analyst

Confidential

Environment: SQL Server 2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Crystal Reports, Visual Studio 2005, ASP.NET, C#, Access Database

Responsibilities:

• Worked with SQL Server Integration Services (SSIS) to create transformations, mappings and workflows and schedule them accordingly in auto-warranty warehouse.
• Developed databases and created indexes, views, stored procedures, user defined functions, cursors, derived tables, and triggers in auto-warranty databases.
• Migrated DTS packages to SSIS and modified using DTS editor wizard.
• Developed customer reports using BIDS in SSRS and scheduled in the report manager.
• Developed web forms using C #and ASP.NET for our automotive client.
• Documented technical aspects and user manuals.