Hi ,
I have an excellent candidate as SQL MSBI DEVELOPER with SSIS/SSRS/SSAS who is open for all over US .
Please send me requirements if any also add me your mailing list mahesh@ipheights.com .
Please find below professional summary for your reference .
Professional Summary:
-- I have an excellent candidate as SQL MSBI DEVELOPER with SSIS/SSRS/SSAS who is open for all over US .
Please send me requirements if any also add me your mailing list mahesh@ipheights.com .
Please find below professional summary for your reference .
Professional Summary:
- 8+ years of IT experience in analysis, design, implementation & administration of business intelligence solutions with Microsoft SQL server 2012/2008/2005 in development, testing & production environment.
- Extensive experience in Requirement Analysis, Work flow analysis, Design, Development & Implementation, Testing & Deployment of complete software development life cycle (SDLC) in field of Desktop Applications, Microsoft web and client/server technologies.
- Extensive experience in Relation Data modelling for creation logical and physical design for databases and proficient in creating E-R diagram using Erwin and Visio.
- Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers and user created data types to provide flexible and reusable modules to be used in WEB technology and client-server Windows technology
- Expertise in creating indexed tables with primary key, foreign key and composite key constraints to maintain referential integrity and to maintain performance
- Expertise in writing and debugging Stored Procedures and Triggers
- Experience using MicroStrategy 9.x/8.x/7i/7.x/6.x product suites including MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Narrowcast Server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web.
- Expertise in generating Crystal reports, Ad hoc reports, tabular reports, Matrix reports, Drill-down reports, Cascaded reports, List reports, Parameterized reports, Sub reports and mentoring end user report writers using SSRS
- Expertise in design and development of SSIS (ETL) packages.
- Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
- Highly proficient in writing functional specifications and translating business requirements to technical requirements
- Hands on experience in the ETL processes using SQL Server Integration Services (SSIS) Bulk Copy Program (BCP) and Data Transformation Services (DTS)
- Develop and implement ETL routines according to data warehouse design and architecture.
- Extensive experience in power pivot modelling, building and maintaining power views.
- Experienced in developing user reports, management reports along with Report Authoring, Report management, Report delivery and Report security using SQL Server Reporting Services from MS Excel and flat files
- Extensively involved in SQL Tuning using SQL Server Profiler, SQL TKProf, Explain Plan, Optimizer Hints to enhance the performance of the complex queries for OLTP Transactions and Decision Support System
- Experience in managing Alerts, Operators and Jobs through SQL Server Agent
- Involved in administrative tasks such as creating user roles, logins, security and permission on database level.
- Extensive knowledge on Data modelling.
- Integrator of relational databases like SQL Server, Microsoft Access and Excel spreadsheets.
Skill set:
| Languages : | T-SQL, C |
| Reporting Tools : | SSRS (SQL Server Reporting Services) |
| ETL Tools : | SSIS (SQL Server Integration Services), Data Transformation Services (DTS) |
| Operating Systems : | Windows XP/95/2003/2008, DOS, Windows Server 2008/2012 |
| Databases : | MS SQL Server 2005/2008/2008R2/2012/2014, MS Access 2005/2007. |
| Database Tools : | SQL Profiler, Data Transformation Services, SSRS, SSIS, SQL Server Business Intelligence Development Studio (BIDS), |
Mahesh Kallepalli | .Sales Lead
P 732-579-3659 | mahesh@ipheight
IP-Heights
NOTE: No layers will be encouraged . Please keep us posted ahead of submission about the Client info and are direct vendors to client .
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment