Sql Server Data Analyst
Resume:
Ashok Malani
*************@*****.***
PROFESSIONAL SUMMARY
Results-oriented Information Technology Professional, with over multiple years of industry experience as Data Analyst, Reporting Analyst, Programmer Analyst, Business Analyst and Developer. Experience in Data Normalization, SQL Server 2016 Business Intelligence, and SQL Server Integration and Reporting Services, Data manipulation (formatting, sorting, and compiling)
• Over 7 years of SSRS and SSIS development Experience.
• Experienced with conversion of Business Object Reports to SSRS Reports
• Experience with formulas including VLOOKUP, HLOOKUP, CONCATENATE, TRIM, PROPER, LEFT, RIGHT, MID and VBA
• Experience with importing and exporting various delimited files and different formats (comma, space, tab, special characters)
• Experience recording, modifying and applying macros (using Visual Basic for Applications)
• Collecting Reporting requirements and creating BR documents.
• Possess strong interpersonal skills with the ability to interact with end-users, managers, and technical Staff.
• Extract Data from the Linked Server through Open Query.
EDUCATION
Bachelors in Engineering, Computer Science - Osmania University, India
TECHNICAL SKILLS
• Languages: MS SQL, SQL Server, VBA, and T-SQL.
• Operating Systems: Windows (2003 - 2010)
• Database: MS SQL Server (2000 – 2016)
• MS Access (2003-2013)
• SQL Server Reporting Services (SSRS)
• SQL Server Report Builder
• SQL Server Integration Services (SSIS)
• SQL Server Analytics Services (SSAS)
• DTS packages SQL Server 2000
• Tableau BI Tool
• Power BI
• Excel power BI
• Open Query
• Excel Power Query
• Excel Power Pivot
• Oracle TOAD
• MA Access 2013
• TSQL Development (DDL/DML)
• Trello Board
• Agile Sprints
• MS Excel 2013
• Share Point
• Text Pad
• Crystal Reports
• Business Objects
• MS PowerPoint
• Cute FTP 8 Professional
EMPLOYMENT HISTORY
Data Analyst III Govt. Program
FirstCare Health Plans Austin, TX (01/2011-02/2017)
• Supporting Government Healthcare programs like Medicare, Medicaid, and CHIP
• Analyzing Data and Creating so many ad hock reports very fast pace on daily basis, helps management and other team members to take better business decisions.
• Creating multiple ongoing reports daily, Monthly quarterly and yearly for internal and external customers like Finance, Customer Service Dept. HHCS and CMS
• Extract data from Several SQL Server databases and warehouses Like AMISYS Health Edge and Voyager
• Using an Open query to extract data from Lined Server.
• Generating various reports on SQL Service Reporting Service (SSRS) and MS Report Builder to support operation team, to take business decisions.
• Working SQL Server 2016 Management Studio tool to write query scripts and creating Store Procedures using TSQL query language.
• Advance working experience on SQL Server 2005 – 2016 day to day work.
• Designing Developing SSIS packages for ETL process with multiple transformations Like Split condition, Data conversion Merge and Merge Joins.
• Designing reports on Crystal and MS Access.
• Using visualization tools like Tableau and Power BI create multiple charts and create and deployed on portals
• Loading data files from different sources like CMS files into Database create reports as per requirement and convert data in multiple formats like CSV, Rich text and PDF as requested
• Also there some reports development on MS Access tool connects through ODBC with SQL data warehouse.
• Always meet my deadline never missed if work needs to work overtime I did that at work or from home.
• More important I love my work and never give up to get the job done.
• Using Trello Board to create cards for projects and manage my work with documentation.
Sr. Reporting Analyst
Magellan Health Services, Richardson, TX (08/2009 - 12/2010)
• Reporting day to day to management to take better business decisions
• Extract data from Oracle database using Toad
• Using Rapid SQL tools for writing query scripts
• Developing SSIS packages to create data tables for reporting
• Designing reports on SSRS and deploying
SQL Server Reporting Analyst
Specialized Association Services, Irving, TX (04/2009-06/2009)
• Converting reports from the Business object into SQL server 2005 SSRS.
• Creating and modifying Store procedure as for report date sets
• Writing Data source Connectivity string in Visual SourceSafe base on
• Global parameters value.
• Testing and publishing on the internal reporting website.
SQL Server BI/Reporting Developer
Alliance Data System Dallas, TX (05/2008-04/2009)
• Create the database tables, indexes, and schemas.
• Developing the ETL process using MS-SSIS and SSIS Utility tool.
• Write the stored procedures in T-SQL to populate the data for confirmed dimensions.
• Responsible for developing the reports (charts, pie, and graphs) diagrams for the various Decision support system.
• Deploying the reports using SSRS.
• Involved in Unit Testing, System Testing, Integration, and Performance
• Communicating client like status report/issue resolutions/understanding the business requirements
• Providing the client documentation, with component and task level details.
• Extracted the data from Excel files, fixed with and delimited files.
• Involved in the Execution and Creation of Test Plans Test scripts and job flow Diagrams
• Designed, developed and published web reports.
• Pulled data from Oracle, SQL Server, Mainframe TSO, Business Object, Ingres and different sources and loading in SQL Server using SSIS, DTS Transformation with different SQL task like updating, deleting adding the column as per report needs.
• Wrote SQL Scripts to pull data from other sources suing MS OLEDB provider, ODBC and dumping that information into SQL server.
• Manipulated data through SQL tasks and made end user access data automatic through SSIS.
• Wrote T-SQL Script to create store procedures and User Define Functions.
• Designed and developed Chart Reports using Access by management to determine performance and compare information with other projects.
• Provided fast-paced Ad-hoc reporting typically requested by field staff for particular data so they could help customers immediately. Provide through an Excel spreadsheet.
SQL Server Database Developer (04/2007-05/2008)
Sprint/Nextel Austin, TX
• Create Dimension and Fact Tables and Data Mart based on the existing Data Warehouse.
• Migration of data from SQL server 2000, DTS packages to SQL Server 2005 SSIS packages.
• Sourced data from various sources like SQL Server, UDB, Flat Files and CSV files
• Developed stored procedures to perform the complex business logic.
• Loaded data to target tables (Corporate Data Warehouse).
• Coordinating with onsite people to manage and progress the work schedules.
• Tuning and Optimizing the procedures, and ETL performance.
• Responsible for writing to the test cases to check the data as well bugs fixing.
• Responsible for running the master package to call all the child packages and loading the data into the target table.
• Involved in writing of the unit test cases.
• Designed, developed and publish web reports.
• Analyzed and manipulated data by making changes through SQL tasks and allowing an end user to have access to data automatic through SSIS.
• Utilized PL/SQL to pull data from Oracle database using TOAD to dump information into SQL Server for Ad-hoc reports)
• Utilized TSQL Script to create Store procedures to call SQL development.
• Developed Reporting Tools used by field staff and supervisors to track daily work to determine performance. This provided immediate information for the customer.
• Provided fast-paced Ad-hoc reporting. Field staff requested reports so they could immediately provide information to their customers. Reports were on Excel spreadsheet or on Crystal Report)
• Designed and developed MS Access Tool. This application helped field staff make changes in the database directly connected by ODBC. The end user could only see the front-end.
• Pulled data using Business Objects data consisted of HR information, which was exported to Excel for training and certification reports, mapping sprint university results and overview of management.
• Environment: SSIS, SSRS, and SQL Server 2005, Business Objects, DTS Packages SQL Server 2000, Oracle TOAD, Crystal Reports, MS Access, MS Excel.
Access/SQL Server Database Developer
Hart Inter Civic Austin, TX (12/2006-02/2007)
• Developed MS Access Database Application.
• Staff used this internal tool to enter daily work. This information was tracked by their supervisors. The application was a user interface file built on VB code, MDE file work as an application.
• Designed various reports using MS Access reports in datasheet views. This information ran automatically from user interface by clicking button based on Access data or SQL server data linked through ODBC by writing queries)
• Utilized SQL Script writing to design queries used for reports and drop down list on an Access database.
• Environment: SQL Server 2000, MS Access, Visual Basic
Data Analyst
MAXIMUS Austin, TX (08/2006-12/2006)
• Designed and developed Pivot Chart Reports using MS Access. This ran directly by user charts changed automatically per data change in tables, providing a larger picture of performance to management.
• Data Analysis pulled data from different sources and analyzed information per report requirement.
• Wrote SQL queries to pull data from source databases and queries from the database.
• Updated forms design through the old database.
• Made changes in design and wrote code for the functionality of forms.
• Utilized Word Document to develop reports
• Environment: SQL Server 2000, MS Access, DTS Packages Visual Basic, MS Excel
DBA VI (MS Access Developer)
Texas Education Agency Austin, TX (03/2006-08/2006)
• Managed a large number of SQL Server databases across multiple servers.
• Monitored and managed custom backup/restore and disaster recovery plans.
• Administer and secure Microsoft SQL Servers.
• Support SSIS packages, SQL Agent jobs, stored procedures, scheduled tasks, batch jobs, and other database processes and workflows.
• Perform routine and periodic database maintenance. Designed and developed the database application using MS Access Tool for internal use to track funding project.
• Developed database instruction manual presentation. (PowerPoint presentation manual for future training for application users)
• Designed and developed various reports. (MS Access reports for director and higher management about projects performance)
• DBA Job on MS Access Database (Repairs and maintenance table normalization up to three levels)
• Environment: MS SQL, MS Access, MS PowerPoint, MS Excel
MS Access Database Developer (03/2001-03/2006)
Pearson Educational Measurement Austin, TX
• Designed, Developed MS Access Application. Internal Department tracking tool to monitor temp employee speed and performance as per project which helps management to switch employees between project per their speed and accuracy on particular project also helps their time card, Errors per project
• Developed various Reports on Excel. Reports were created Spreadsheet through ODBC link, based on daily work entered on Access database on next day early morning to calculate and quality of last day work)
• Provided support to users during process (help users on software applications used for work tracking system we have lot temp employees need training how to use tools)
• Prioritized jobs on the mainframe. (Jobs submitted by deferent users and run as per submission, however some needs to done first I have priorities as per user request)
• Jobs submission on Mainframe (submit printing jobs on Mainframe TSO)
• Controlled and monitored production (school test documents for printing needs to check physically and also on Mainframe system, investigated cause of failed jobs on TSO and fixed problems)
• JCL Update as requested
• Batch creation and logging
• Administered the WFM system (including "Route Control Block creation", and batch prefixes)
• Environment: JCL, TSO, CICS SQL, MS Access, Visual Basic, MS Excel, Windows 2000
Contact this candidate